Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS packages\jobs connecting to Linux DB2 fail randomly with message:SQLAgent job failed. process exit code was -10737418 RE: SSIS packages\jobs connecting to Linux DB2 fail randomly with message:SQLAgent job failed. process exit code was -10737418

  • I had the same issue with AS400 DB2 but it only affected 1 package of about 12 that read from the same system. The package was working fine until a added a script task to lookup the error description. No matter what I didn't the package would throw random error massages or work. I tried wrapping a try catch around the script command - No luck. The exact same script command works perfect in another package that is run in the same job just prior.

    I finally gave up and just deleted the script command. I can lookup the errors myself if I really care but most of the error related to inserts/updates are pretty obvious: Missing data or key violations.

    If anyone finds a solution i would love to know!

    -Mike