SSIS - Skip Missing Files

Posted by Greg on Stack Overflow See other posts from Stack Overflow or by Greg
Published on 2010-06-14T18:07:44Z Indexed on 2010/06/14 19:02 UTC
Read the original article Hit count: 268

Filed under:
|
|
|

I have a SSIS 2008 package that calls about 10 other SSIS packages (legacy issues, don't ask).

Each of those child packages loads a specific file into a table. But sometimes one or more of these input files will be missing.

How can I let a child package fail (because a file is missing) but let the rest of the parent package keep on running?

I've tried increasing the maximum error count on the parent package, the tasks in the parent package that call each child, and in the child package itself. None of that seemed to make any difference. I still get this error when I run it with a file missing:

SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Edit: failpackageonfailure and faulparentonfailure are already all set to false everywhere.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server