You can use the Insert into XML Column
wizard to insert
XML data into an XML column. You can open the wizard from XML files
or folders that are stored in a data development project.
Before you can complete the wizard, you must complete
the
following prerequisite steps:
- Create a connection to an XML
database in the Data Source Explorer.
The database must contain at least one table with at least one XML
column.
- Create a data development project that is associated
with this
connection.
- Create or import XML files to the data development
project.
To insert XML data into an
XML column from the Data Project
Explorer:
- Select an XML folder or one
or more XML files that are
contained in a data development project in the Data Project Explorer.
- Right-click, and select Insert into XML
Column. The Insert into XML Column wizard
opens.
- Complete the steps of the wizard,
then click Finish. You can select
an XML column to insert the data, and you can
optionally select an XML schema to validate the insert. For additional
help about the wizard, press F1.
The
data from the XML files that you selected is inserted
into the XML column. You can view the results of the actions in the
Data Output view, including any errors or failures. Each insert is
performed separately, so if you are performing multiple inserts at
the same time, the success or failure of each insert is displayed.
You can also view a sample of the data that was inserted by right-clicking
the XML column in the Data Source Explorer, and selecting .