In setting up a datawarehouse we're starting out with about 30 tables
that need to be transfered. What I would LIKE to do is build a lookup
table that holds the Names of those tables in their source, and the
names we are going to use in the warehouse, then cycle through that
list with a ForEach Container to copy the table, compare to the
previous days table, log if different drop previous and rename the new
one.

Easy 4 step Control Flow dtsx.

question is. How can I get the table name out of the lookup table and
use it in my package?

I've seen how to set the server/catalog in a config file (nice for
connection stores!) But Has anyone tried pulling in multiple table
names yet?

Ches Weldishofer
Clear Channel

Ches Weldishofer wrote:
To drive a loop off a table, get the data into a variable using an Exec
SQL Task, results as full row set. Then For Each Loop with the ADO
enumerator to get the values out and split them into variables for use
within the loop.

--
Darren
http://www.sqldts.com
http://www.sqlis.com

Thank you Darren, but that wasn't the problem.

The problem is getting SSIS to recognize a variable as a table name
when setting up the destination. From what I can see you can only
choose an existing table, or create a new table. The Tablename field
does not allow you to type in a variable or a tablename.

(Hopefully they'll change that part, since it's often faster to type in
a table name than search it in a list)