Post reply

assert variable and fail component

  • May 22, 2014 at 6:33 am

    #307632

    Hello,

    I want to fail a dataflow/controlflow when an uservariable has a non-zero value.

    Something similiar than the error output redirection that has the option to fail.

    Situation:

    Read from source, redirect errors to an error table and errorcount variable.

    Next step: check if errorcount is greater than 0->stop/fail containter/chain

    Is there an example?

  • May 22, 2014 at 7:12 am

    #1715680

    Something like this should work - a simple stored procedure with an @ErrorCount parameter. If @ErrorCount is 0, do nothing, otherwise raise an error that will cause the task to fail.

    John

  • May 22, 2014 at 8:47 am

    #1715724

    Thanks for the suggestion. Is certainly a way to achieve the goal.

    Went for a scripttask in the controlflow setting and setting the result to Dts.TaskResult = (int)ScriptResults.Failure; when variable was > 0

    Example of reading ssis variables into script

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

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