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?
kenweber
GCom2 Solutions
Microsoft Certified Professional