sql server dts: SSIS -- sql server dts

SSIS	farshad 2/27/2007 6:22:08 AM

sql server dts: I would like to have a SSIS package which loops through each xml file (.xml
files) in a folder on the network. And then for each file pull out the data
and insert into a sql server table.
Please kindly guide me through this i.e. What task(s) are required, etc.

Re: SSIS

Allan Mitchell
3/2/2007 4:45:03 AM

You will need a ForEach Loop container to loop through the files and
then use the XML Source Adapter in the pipeline to import the file.

It will look pretty similar to this.

Looping over files with the Foreach Loop
(http://www.sqlis.com/55.aspx)

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.