Home All Groups Group Topic Archive Search About

How to Copy a DTS Package to Another Server in Enterprise Manager?

Author
3 Aug 2006 2:45 PM
Emily
I'll need to copy (or move) a DTS (Data Transformation Services)
package to another database server. I want to know what steps I should
follow in order to accomplish the task in Enterprise Manager.

In Enterprise Manager, the package is located , under the current
database server, "Data Transformation Services"->"Local Packages". I'll
need to move it to another database server, "Data Transformation
Services"->"Local Packages".

Thanks!

-Emily

Author
3 Aug 2006 5:32 PM
Tracy McKibben
Emily wrote:
> I'll need to copy (or move) a DTS (Data Transformation Services)
> package to another database server. I want to know what steps I should
> follow in order to accomplish the task in Enterprise Manager.
>
> In Enterprise Manager, the package is located , under the current
> database server, "Data Transformation Services"->"Local Packages". I'll
> need to move it to another database server, "Data Transformation
> Services"->"Local Packages".
>
> Thanks!
>
> -Emily
>

Open the package, then "Save As" to the new server...


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com

AddThis Social Bookmark Button