Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)
I have a control flow SSIS kit that includes a bunch of sql tasks executed in a sequence.

For each of the tasks, I need to test a flag and run the task if set, if not skip and go to the next one.

Each of these tasks performs a stored proc. So if not set, I can test the proc and "Return" If any, I was looking for a solution called "SSIS."

1 Answer

0 votes
by (47.2k points)

Click on the arrow between your control flow functions, and pick Delete. When you do this, you get a dialog that allows you to test the task's "constraint" (success, completion or failure), an "expression" (i.e. you can return a value to your executed sql task,store that value in a variable, and check the value of that variable in an expression to decide if you want to continue down the path you are editing), an "expression and a constraint," and a "error". Except for the rationale, these last two are the same. "Expression and limitation" needs a true condition on both expression and constraint; "expression or constraint" requires a true condition on only one of the language and constraint.

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.

Related questions

0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
asked Feb 27, 2020 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer

Browse Categories

...