Hi,

I have 2 DTS Packages, one is a child which is run by the other the parent
using the execute DTS task. The child has logging configured to point to a
particular server, also the child has a dynamic properties task which uses a
global variable to set the logging server. If I execute the child package
directly it works as expected, not ideal since I need to run the package
twice to get the logging server to change but i understand why.

However if I try to change the logging package from the parent package it
just doesn't seem possible... My ideal situation would be to overide the
local variables with the outer package variables and get the child package to
configure logging using these... any ideas or am I stuck with doing this at
the child level each time?

You cannot do this as you describe. The Dynamic Properties task is inside
the package, so the package is already running. At this stage changing the
server will have no effect as logging has already started.

You need to load the package, change the settings, then execute it. No
option to do this on the Execute Package Task, but it you could do this if
you used an ActiveX Script Task instead.


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


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