Hi there,

In my DTS package, I want to define my connection DataSource using dynamic
properties. I'm using a query to initialize the source.
Can I use a global variable in this query and how to use it ?

Thanks for all
VinCe

You can use a global variable (parameter) in a query within the Exec SQL
Task, the Data Pump task and the Data Driven Query task. You cannot use
parameters in a query fro a Dynamic Properties Task assignment.

You could use an Execute SQL Task to run the parameterised query and assign
the result to a global variable, then use the Dynamic Properties to assign
the global variable to the final destination.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"VinCe" <VinCe (AT) discussions (DOT) microsoft.com> wrote

thanks for your help !
I will use your solution, with the result of the query in a global variable.

VinCe


"Darren Green" wrote: