Drag the XML via SQL Data Provider component onto the Design window.
In the Properties window, click the XML Source icon and select the XML to use as a data source. You can specify HTTP, FTP, URL, or file name.
Click the Data Output icon.
Click the Properties icon to open the XML Port Manager. Specify a query for each output port.
XML via SQL Data includes one output port by default, but you can add ports. Any OUT-ports you add in XML Port Manager appear in the Design window. For additional information, see “Working with XML Port Manager”.
Updating the output port structure
To update the output port structure to reflect changes made to the XML source file:
Right-click the XML via SQL Data Provider component.
Select Reconfigure.
The Reconfigure option updates the component configuration when there is a change in the database schema. It closes the current connection, opens a new connection to the database, reads the XML source file, and applies the updates to the output port structure.
