Copy DTS package to another domain/server -
05-21-2004
, 12:41 PM
We have a simple DTS package that executes a Transform Data task to load an Excel spreadsheet into an SQL table. It has been tested and works fine. We need to send this package to another group to be installed in their domain on their SQL server, both of which we know the names of but do not have access to. How can we update this package to have the name of the domain, server, owner, etc. and save it so that, when we send it to the other group, they do not have to modify it in order for it to work. Disconnected Edit and save as a .dts file? If so, which fields? Thanks. |