February 8, 2008 at 10:06 am
I have a package with an FTP task which copies files from various locations on an FTP site specified in a table (i.e. in a ForEach Loop)
There are several hundred iterations in the ForEach loop. Many of the ftp locations do not contain files. Hence the ftp task generates an error.
What happens is the package reaches the maxerrorcount of 100, and bombs out before it completes
How do I force a success result of the FTP task to avoid the errors. I have tried event handlers and various combinations of ForceExecutionValue, but nothing seems to work
I'm sure someone else has come across this
Help appreciated
thanks
February 8, 2008 at 10:16 am
I think you were going down the right track with your eventhandler. Use the OnError event and change the variable [@system::propagate] to FALSE. This should suppress the error so that the parent container is unaware of it.
Another option that may help your situation is to download all the available files to a local directory from the FTP folder concerned that matches a given filemask and enumerate through the local folder rather than the records in your table.
Kindest Regards,
Frank Bazan
February 12, 2008 at 5:30 am
Hi Frank
that seems to have done the trick very nicely!
I'm eternally grateful
Regards
Phil
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply