I am using DTS to export seven tables from Sql to Excel.
The structure and field names of each table are exactly the same.
However, each table has a different name.
I'm using a global vaiable within an ActiveX Script Task for the table
name and would like to create some kind of loop to handle the export
instead of having seven data pumps.
I've read quite a bit the last few days on various websites regarding
how to do this. I've even downloaded some code.
However, I just can't seem to piece it all together.
Does anyone have any concrete examples on how something like this can be
accomplished?
I've been pulling my hair out (and I'm bald already!).

Thanks in advance,
DL