Hi there,

I spent almost 6 hours searching through the net and reading ...
unfortunately without any success.

What I want to do is to export different tables into different excel files.
The only information is the table name and the directory where the excel
file will be stored.
Different tables have different fields.

I want to create a DTS task with 2 global variables g_TableName and
g_ExcelName that in result will export the table called g_TableName into the
file g_ExcelName.

I tried writing custom ActiveX Script task.
If I use only ActiveX Script to define/open all of the connections I need
to define also the transformations there. So I just can't use it with
different tables as far as I don't know the table structure beforehand.
(Inspecticng the table structure is not a solution - too hard to implement
and better do it with ADO outside DTS).
If I use ActiveX Script with MS OLEDB connection and Excel connection the
transformations become invalid right after I change the table and/or the
excel file.

Isn't there a way to tell to the DTS - export all fields or something like
that ?

Please help!

sunsande