When you add XML via SQL Data Provider to a project, Sybase ETL opens a properties section and prompts you for the source file. Identify the source file, then assign the data output properties.
To enter required properties
Select the XML Source file. This can be an HTTP, FTP, URL, or a file name.
Click the XML button of the Data Output property to open the XML Port Manager.
Specify SELECT statements based on the table structure created from the XML document for each output port (see description of the XML Port Manager below). There is one output port per default, but you can add ports. To create the SELECT statement, you can use the Query Designer.
