selectively execute task in ssis control flow

Question

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."

Answer 1

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.