I've created a global variable to use in the Transform
Data task for my table source and table destination thru
Dynamic Property task. It works fine when -- I go to
package property and change the global variable value it
also change on the source and the destination tab of the
Transform Data task however it does not change the
tranformation automatically. So, I have to go to the
tranformation tab and redo manually. Therefore it defeats
the purpose of using the global variables. Am I missing
anything? Thanks in advance for any help.

Are you saying that after you execute the package through a scheduled job,
VB or DTSRUN etc when you reopen the package the values have not been set to
your Dynamic Properties task settings ?

If so then this is the way it works. Unless you save the package back after
changing them they will stay set to the Design Tome values when you look at
the package but will still change when asked through the DP task.

OR are you saying that they are simply not changed when you run it through
DTS Designer either?

--

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


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