selectively execute task in ssis control flow

I think your question was the same as mine in which I wanted to control execution of a task “inline” in my control flow.

The easiest way that I have found doesn’t involve expression on the data connectors between the control flow objects but rather using expressions on the control object itself and setting the “Disable” value using an expression. This way on execution, the object is either skipped or not based upon the expression evaluation.

As an example, I wanted to execute a “Execute SQL Task” to remove my indexes based upon whether a variable named “ExtractType” was equal to “Full”. If it was then I wanted to remove the indexes on my tables before doing my full load.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)