Hi
I'm trying to use Dynamic Property Task to set SQL Statment for a
transformation.
I'm assuming this is possible by going into the Disconnect Edit properties
of the package.

I have a DTS job set up and it also runs successfully, but the sql statment
associated the the transformation does not change.

Any help is greatly appreciated, i got very little from MS site or even
google searches.
I can also provide details on what I am doing if need be.
Thanks

No.

The DP task and the Disco Edit features whilst similar to look at are
different.

In the Disco Edit you get to set properties specifically and only at
that time. It will not read an external source to get its values
whereas the DP task will.

The DP task is the way forward for you here.

Allan

"Rashmi Jagadish" <RashmiJagadish (AT) discussions (DOT) microsoft.com> wrote in
message news:RashmiJagadish (AT) discussions (DOT) microsoft.com:

Alan,
I'm a little lost here. SO what is the DP's Query property used for??


"Allan Mitchell" wrote:

The DP Query property is used to query something and assign the value
returned to something else.
For example, you could have a global variable called gv_CurrentDateTime, and
in the DP, you could set up a new property, find the gv_CurrentDateTime
variable, select the source of the gv to query, and in the query write
SELECT GETDATE(). Then, when the DP is executed it assigns the gv to the
current date and time.

So, as for your question about dynamically setting the SQL for a data pump
task, you would open the dynamic properties task, click add, find your data
pump task in the "Tasks" node, scroll down (on the right) to
"SourceSQLStatement", and double click it. It then pops up how you would
like to set that property.
You can assign it any INI file value, Query, Global Variable, Constant, etc.

Depending on how you want to dynamically create your SQL statement will
dictate what type of source property to use.

--
Simon Worth


"Rashmi Jagadish" <RashmiJagadish (AT) discussions (DOT) microsoft.com> wrote in
message news:1D0AD080-1314-4104-B304-15B04A3C9793 (AT) microsoft (DOT) com...