I have a table which contains the file location for each vendor.
For ex. tblVendor
Vendor Location
ABC C:\ABC\Results1.xml
SBC D:\Results2.xml
TNS C:\Results3.xml

I want to loop through this table and select and retrieve the xml file path
for each vendor. Then use this in XML source and then populate the table.

The .XSD file for all the .XML files are same.

So, basically in XML source task the xml file location should read through
the variable.

How do I loop through the table tblVendor and have the variable value set to
filelocation?

Any help is appreciated.

Thanks!