Mar 7, 2006 #1 jararaca Programmer Jun 1, 2005 159 US Hi, Is there a way to copy a DTS package from one database to another (on different SQL Servers, both of which are registered in Enterprise Manager)? Thank you.
Hi, Is there a way to copy a DTS package from one database to another (on different SQL Servers, both of which are registered in Enterprise Manager)? Thank you.
Mar 7, 2006 #2 SQLDenis Programmer Oct 1, 2005 5,575 US yes open package then package-->save as change the server name (and provide credentials if it's not window authentication) and you are done Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/ Upvote 0 Downvote
yes open package then package-->save as change the server name (and provide credentials if it's not window authentication) and you are done Denis The SQL Menace SQL blog:http://sqlservercode.blogspot.com/ Personal Blog:http://otherthingsnow.blogspot.com/