You can use the Insert into XML Column
wizard to insert
XML data into an XML column. You can open the wizard from an XML column
that is displayed in a database connection in the Data Source Explorer.
Before you begin
- 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 XML files on the local file system, or in
a data development project.
About this task
To
insert XML data into an XML column from the Data Source
Explorer:
- Select one XML column in
the Data Source 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 XML files from the file system to insert into
the XML column, and you can optionally select an XML schema to validate
the insert. For additional help about the wizard, press F1.
Results
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 .