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 OUT-port.
By default, XML via SQL Data includes one OUT-port, but you can add ports. Any OUT-ports you add in XML Port Manager appear in the Design window. See “Working with XML Port Manager”.
Updating the OUT-port structure
To update the OUT-port structure to reflect changes made to the XML source file:
Right-click the XML via SQL Data Provider component and 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.
