"Darren Green" wrote:

>
> 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@discussions.microsoft.com> wrote in message
> news:F46F66F8-FAA0-4379-8A34-8DCB6C27B49F@microsoft.com...
> > 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
>
>