That would alos be a good solution.  Since I have a select statement that defines the tables I need to copy, I can pass the list to a table, temp table, sursor, etc. 

I am mystified about how I get that result set into DTS so it can use it.