SSIS 'Execute SQL Task' - dynamic SQL

Demonstration of building a SQL command from separate variables to allow dynamic SQL with "Execute SQL Task" (using SQLSourceType=Variable).
Also shows how to use "Expression Task" to build the SQL command.

[antoniolupen]

Where did you get the watch1 window? how did you configured it to display 'Name' and 'Value' ???
Also, what would be the effect in the SQL server ? I see nothing happen. Thanks in advance

[kennethrosever]

This works but, am I correct that I can't put this in some kind of loop, where the target table and output columns may change on each loop, since the metadata is set at compile time?

[ishwetareddy]

For me column name which is dynamic from a for each loop is not appearing in expression task. Any idea