Post reply

SSIS Package Fails, but Agent says it was a success

  • August 22, 2016 at 8:56 am

    #311386

    Longtime SSIS 2005 user, but new to 2012 and the SSISDB catalog, and so far, not really a fan. I have an SSIS job that is called from a SQL Server Agent on a different server. The job completed successfully, but when I look into the report on our SSIS server I see I got data mismatch "conversion failed" error. Why didn't the SSIS get passed on to the agent?!

    Thanks in advance.

  • August 22, 2016 at 10:21 am

    #1896704

    Jon Brune (8/22/2016)

    Longtime SSIS 2005 user, but new to 2012 and the SSISDB catalog, and so far, not really a fan. I have an SSIS job that is called from a SQL Server Agent on a different server. The job completed successfully, but when I look into the report on our SSIS server I see I got data mismatch "conversion failed" error. Why didn't the SSIS get passed on to the agent?!

    A couple of things that could impact that would be the FailPackageOnFailure property for task and MaximumErrorCount for package.

    Sue

  • August 22, 2016 at 11:15 am

    #1896715

    Thanks Sue. FailPackageOnFailure was TRUE for some of my executables, but not others, for some reason unknown to me.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply