Hi,
We have a DTS package that reads two txt files and loads them to a
database.
The Destination DataSource, Catalog, UserId and Password are being read
from an INI file.
The loading is thru Transform Data Task.

When we move the package from one server to another and change the INI
file accordingly, the DynamicProperties is successful, the package
correctly reads the Source and Destination, however, the Transform Data
task remembers the old destination, and keeps failing since the user ids
are different from the old location.

Any advice is helpful.
Thx
AnsG

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!