Click to See Complete Forum and Search --> : DTS: Changing a connection


Ken Weber
03-14-2000, 06:16 PM
Is it possible to change a connection to another server without losing my
data transformations? I've developed the package using MSDE on my local
machine, and now I need to move it to our SQL Server.

Once I've got it on our server, I'll need to switch the connection to use
our Test, Acceptance, and Production databases. Is this possible?

TIA!

--Ken