Import XML using FOREACH Loop container

7 Sep 2006 9:36 PM

UA

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!

8 Sep 2006 7:12 AM

ML

Is this a DTS or a T-SQL question? What version are you on?

ML

---
http://milambda.blogspot.com/

9 Sep 2006 10:33 PM

UA

I am trying to do in SSIS using FOREach Loop container

Show quote

"ML" wrote:

> Is this a DTS or a T-SQL question? What version are you on?
>
>
> ML
>
> ---
> http://milambda.blogspot.com/

11 Sep 2006 7:59 AM

ML

Perhaps you should ask this question here:
microsoft.public.sqlserver.dts

ML

---
http://milambda.blogspot.com/