May 22, 2014 at 6:33 am
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
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
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy