locked
handling abnormal termiantion of underlying Stored Procedure RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    I have a scenario SSIS calls --> Stored Proc.

    Is there a way to error handle in such a way that if SP fails (abnormally), SSIS should gracefully exit, instead of failing as well

    could you please advise

    thanks
    Wednesday, March 2, 2016 4:50 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi etl2016,

    sure you can, and in a number of ways.

    The preferred is to use the Sequence Container http://sqlblog.com/blogs/rushabh_mehta/archive/2008/04/24/gracefully-handing-task-error-in-ssis-package.aspx

    Arthur

    MyBlog

    Twitter

    • Proposed as answer by Eric__Zhang Thursday, March 3, 2016 6:47 AM
    • Marked as answer by Eric__Zhang Thursday, March 17, 2016 11:30 AM
    Wednesday, March 2, 2016 6:03 PM