North West Business Intelligence Ltd North West Business Intelligence Ltd

Business Intelligence Consultancy

 
  • Increase font size
  • Default font size
  • Decrease font size
Home Technical Tips How to prevent FTP Errors failing SSIS package

How to prevent FTP Errors failing SSIS package

E-mail Print PDF

Stumbled on an issue today designing some FTP management SSIS packages for a client.  The job needed to tidy up after itself and delete any files from the FTP server that it had successfully retrieved and validated.  Unfortunately, once a backlog of files started building up, the package was trying to delete files on the FTP server that didn't exist and the whole package stopped dead even though this wasn't a critical error.

I tried the various Force Success methods available through casino en ligne casino spiele gratuit the normal pokies aussie Control Flow options but none worked, the package always stopped and wouldn't handle casino online holland the problem.

So after visiting this link the solution was simple if a little strange.  To summarise, you need an event handler on the FTP step and set the ForceExecutionResult value to Success.  All works nicely now and as I'm not interested in the errors anyway it handles them beautifully.

Last Updated ( Tuesday, 14 May 2013 17:31 )