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”.