I migrated a package from serverA to serverB. The package reads the log
server name from an INI file via a dynamic properties task.
However, the package fails to execute on serverB. It still tries to connect
to serverA though the INI file shows the value as serverB.
Refreshing the dynamic prop shows that correct value (serverB) but the
package still fails when executed.

What should I do to make the DTS package read the server name from the INI
file? I have already used the INI file & dynamic props- which does not work
for some reason.

You might try Disconnected Edit and see if you can find any references to
ServerA.


"Shail" wrote:

Check out this article that I wrote which addresses these very issues.
http://www.mutuallybeneficial.com/in...s_portable.htm

Pay special attention to the part about logging as this will help you sort
out what is happening.
You can use this script to log what the values of your connections are in
the package at runtime:
http://www.mutuallybeneficial.com/co...ing_Script.txt

--
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David (AT) MutuallyBeneficial (DOT) com

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