Hello,

I am trying to modify some DTS packages so that I can easily migrate
them from server to server without having to go through all the DTS and
change server names and database names which are configured in the
connections.

I have read and am trying to use a Dynamic DTS task which reads data
from and ini file on the computer disk.

However, I am having trouble.

There are some SQL tasks in the DTS which look like....

truncate table tablename

or

update table set value = X where value = Y

There is already a selected database connection in these task and when
I try to select the new one I created, it said that SQL is not
supported by this type of connection.

Can anyone point me in the right direction... I will be very thankful.

Allan