Configuring an XML Via SQL Data Provider Component

Add and configure an XML Via SQL Data Provider component.

1. Drag the XML via SQL Data Provider component onto the Design window.
2. In the Properties window, click the XML Source icon and select the XML to use as a datasource. You can specify HTTP, FTP, URL, or file name.
3. Click the Data Output icon.
4. Click the Properties icon to open the XML Port Manager. Specify a query for each output port.

   By default, XML via SQL Data includes one output port, but you can add ports. Any output ports you add in XML Port Manager appear in the Design window.

• Updating the Output Port Structure
  Update the output port structure to reflect changes made to the XML source file.