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.
Prerequisites: Before you can complete the wizard, you must
complete the following prerequisite steps:
- Create a connection to an XML database in the Database 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 Database Explorer, and selecting .