sql server dts: directory listing in SSIS -- sql server dts

directory listing in SSIS

asafyacobi NO[at]SPAM gmail.com
3/4/2007 12:36:22 PM

sql server dts:

Hey everyone,

I am trying to download a directory via FTP and then import all the
tables to a DB.
The number of files and their names are unknown.
I would probably need some technique to perform a directory listing.
( On the remote directory or its local copy).

Do you know how this could be done in SSIS?

Thanks!
S

Re: directory listing in SSIS

Allan Mitchell
3/5/2007 12:25:27 AM

Have you looked at the ForEach Loop Task. It will enumerate files in a
given directory and if you want their subdirectories also.

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]

Re: directory listing in SSIS

asafyacobi NO[at]SPAM gmail.com
3/5/2007 5:56:51 AM

thanks!
big help.

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.