dbTalk Databases Forums  

SSIS FTP Task fails when file does not exist

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS FTP Task fails when file does not exist in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Siebert
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.