MS SQL Data Warehousing - Sql Server 2005 FTP Task

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Sql Server 2005 FTP Task

timdennis30@gmail.com

2006-02-11, 9:23 am

How do you loop through files on a remote server using the FTP Task?
The ForEarch Loop won't work because the files are stored on an FTP
server which needs a ftp connection string. The ftp task looks like it

only works for one file at a time. The file names are not known before
the package runs, so I just need to loop through all files and transfer

each one.

Thanks

Sponsored Links