I have to write a flexible export system. I want to create a temp table on
the fly via dynamic sql (the structure can be very different each time) and
use DTS to be able to export to ascii files, excel files or even to another
sql server table that the structure can be different on.

Will dts be able to handle these dynamically changing table structures for
the source and destinations?

Thanks..
Tommy

In article <ubeDpnzkDHA.1656 (AT) tk2msftngp13 (DOT) phx.gbl>, Tommy Martin
<tommy.martin (AT) DONTSPAMMEsoftware-plus (DOT) net> writes
No, but it could. It would be up to your to dynamically build the
transformations required for the DataPump. DTS will not handle this
itself. It can be done since you can obviously query the structure of a
SQL table and this will give you sufficient information to build the
required package but it is not a simple task. I suggest you would want
to implement this functionality through a program written in VB or
similar. Use the Save As VB option to get some sample code and see how
it might work.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I would avoid anything to do with DTS, the product is full
of bugs, unstable and hard to maintain.


Ahmed.