SQL Server 2005 FTP Task (SSIS) -
01-04-2006
, 12:41 PM
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 |