Configuring 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 data source. 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.

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