I have a DTS package that sends data from server A to server B. I have to change that to send from server A to server C. Can I simply duplicate (copy) the package to a new name and change the connections in the new package? That is, it will have the same connection names as the old package. Changing connections means changing only the server, login and password.
Steve