Inserting XML data into an XML column from the Data Source Explorer

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.

To insert XML data into an XML column from the Data Source Explorer:

  1. Select one XML column in the Data Source Explorer.
  2. Right-click, and select Insert into XML Column. The Insert into XML Column wizard opens.
  3. 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.
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 Data > Sample Contents.

Feedback