Hi,

I would like to know if it's possible to do that from a DTS Package.

I have a table with these following fields :

SourceDataTable
SqlQuery
DestinationFile

I need to read this table and for each record
to change all the parameters from my dts package.
Right now, I know how to do these following steps :
- Read and make a loop from The Table
- Change the destination file name

But I don't know how to send the Sql Query and source Datatable to the
Transform Data Task

Any help ?

Stan

Ahhhhhhhhhh

You can but it will involve serious work. DTS builds mappings between
source and destination. To change these means dropping and recreating the
mappings everytime. Whilst this can be done it is an undertaking to do and
may not be best done through DTS.

You could use BCP and build the statement dynamically.





--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Stan Sainte-Rose" <stan (AT) cyber972 (DOT) com> wrote

Wowww.. I 've heard your "ahhhhhhh" here in France...
Ok, I will work my problem in another way.

Thanks

Stan

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> a écrit dans le message de news:
elHCjLIIEHA.1944 (AT) TK2MSFTNGP11 (DOT) phx.gbl...