[SQL] List of Tables into ForEach Loop Container, I want to use these as a Source and insert...

I'm trying to use SSIS to handle this (what I thought would be basic) request.

This is what I have set up:

• Source connection
• Destination connection
• I have a list of tables in an Execute SQL Task that I'm using to populate a variable object called TableList.
• I have added a Foreach Loop Container and mapped a variable called TableName that is being populated by TableList.

I have successfully executed a TRUNCATE TABLE ? SQL Task to test the package against multiple tables in the destination.

What I would like to do is use the TableName variable as a Source and Destination table for some sort of data flow. The source table is just a table heap full of data, no structure. The destination has the same exact columns but identity definitions, indexes etc.

Is there a way I can loop through this table list and set this up without creating separate data flow tasks per table?

Continue reading...