Hello,

I am working on a ASP application , where data should be exported to Excel,CSV and MDB formats.

I am fetching the data and I am inserting this data into a table created at runtime, therefore this temp table is dynamic, because the fields will differ every time.

I have to move data from this to excel using DTS package, in the DTS package I created Execute SQL Task, which holds the Create Table Query or Drop Table Query , since the structure of the table varies dynamically, The Create Table Query in the Execute SQL Task needs to be dynamic in nature.

Please help with information on how i can do this.

This is pretty urgent.

thanking you

Sasidhar

thanks,
Sasidhar

__________________
thanks,
Sasidhar

Check out www.sqldts.com they a lot of information you can use to dynamically update your DTS package.

Good luck!
Jeff