Phil Parkin (8/11/2010)
If you want to put data in them too, you might find this a challenge.
Ummm... No.
Use an ExecuteSQL task to create the table, then a DataFlowTask with a Success Constraint that will transfer the data from the source into the table.
Rich