SSIS FTP Task fails when file does not exist -
02-23-2006
, 10:00 AM
Is there any way to make the SSIS FTP Task ignore the case when you try to
retrieve a file that does not exist on the remote FTP server?
We have a job that attempts to get the last 10 days of files from an FTP
site (the dates are included in the file name), but there are no files posted
on weekends. What we currently do is create a list of potential file names
for the last 10 days, and retrieve all that exist. In DTS, we could create
the source file list with all the files, and it would retrieve what it could.
In SSIS, I've placed the last 10 days of file names in a collection, and am
attempting to loop through the collection in a foreach loop with an FTP Task
inside the loop. However, when it tries to retrieve a file that does not
exist, the whole package fails.
Thanks for any help in advance.
David |