I have a script task in my SSIS that has been ok and now it keeps failing when I run it as part of the package, if I run it seperately it is fine.
If I put a break point in code it goes right through and out the code then fails. Not done anything to it, been working on other parts of the system.
I tried putting maximum error count to 2,then 10 then 100 and it still fails but not telling me what on and the code isn't going into err handler.
quote:SSIS package "Package.dtsx" starting. Error: 0x8 at Check if to run: The script returned a failure result. Task failed: Check if to run Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) 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. SSIS package "CD_Replication.dtsx" finished: Failure.
Ok I got it, we have a table in the DB the script task sets to 1, and this value is set at the end of the package back to 0, I must have interrupted the package run and left it set to 1 then when it re ran it went into a ScriptResults.Failure when the script task checked the value. However we have a task to handle this although it doesn't reset the DB value back to 0 - I think that needs to be included.