Post reply

Package Fails, but returns Success Code???

  • October 15, 2008 at 7:30 am

    #126113

    I have an SSIS package with an Execute SQL Task in the OnError event of the package. When I execute the package and know it will fail...it fails and data is getting logged via the task, but the package itself is returning a code of successful (which is not the desired return code).

    Can anyone help me with why this is?

    Thanks!

    Michael

  • October 15, 2008 at 7:49 am

    #885211

    Components have a fail package on failure property. Make sure these are true. Also, by your post it sounds like you may have a task in your event handler and you are not using the built in logging? If that is the case, the task in the event handler succeeding can reset the package to being successful and you may have to force the task in the event handler to always report failure.

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

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