Post reply

how to stop the package based on a condition?

  • March 4, 2013 at 2:38 am

    #274813

    Hi,

    Based on the value of a variabale getting set, I want to stop my SSIS package (successfully) without going to next tasks within the package. Can this be done? Please provide your inputs.

    Example:

    I have a stored procedure getting executed in SSIS execute SQL task. The value of output parameter of this stored procedure is getting stored in a SSIS varaible. If the value of this variable comes out as 1 then package should proceed further but if it gets set to 0, then package should stop there itself.

    Regards,

    Sachin

  • March 4, 2013 at 2:46 am

    #1592919

    You are probably looking for constraint expression.

    Check here

    http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspx

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • March 4, 2013 at 2:59 am

    #1592927

    For Next Step execution based on result from SP:-

    Double click on the Connection Arrow as success and constraint as follows

    @SSISVariable==1

    Just leave with above condition

    if condition not satisfied it completes the Package & gives success results.

    If the condition validated it goes to next Task .

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

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