data transformation services: copy package | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

data transformation services: copy package

How does one copy a package from one server to another?
——————————————————————————– You can copy or move MSDB using COPY DATABASE WIZARD, but make sure to modify sql connection properties if sql server name changed. Otherwise,open DTS package in design view in EM and save as .dts file. Open dts file in new SQL machine Enterprise Manager and save as to the local SQL Server. HTH Also refer to http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=204] _________
Satya SKJ
Be ware of the incompatibilities between DTS packages for different service pack levels on SQL Server 7.0 when saving them as dts files.
Service packReadsWrites
———————–
SQL Server 7.0 SP1SQL Server 7.0 SQL Server 7.0
SQL Server 7.0 SP1SQL Server 7.0 SP1 SQL Server 7.0 SP2SQL Server 7.0 SQL Server 7.0 SP2
SQL Server 7.0 SP1
SQL Server 7.0 SP2 SQL Server 7.0 SP3SQL Server 7.0 SQL Server 7.0 SP2
SQL Server 7.0 SP1SQL Server 7.0 SP3
SQL Server 7.0 SP2SQL Server 7.0 SP4
SQL Server 7.0 SP3SQL Server 2000
SQL Server 7.0 SP4SQL Server 2000 SP1
SQL Server 2000SQL Server 2000 SP2
SQL Server 2000 SP1
SQL Server 2000 SP2 SQL Server 7.0 SP4SQL Server 7.0SQL Server 7.0 SP2
SQL Server 7.0 SP1SQL Server 7.0 SP3
SQL Server 7.0 SP2SQL Server 7.0 SP4
SQL Server 7.0 SP3SQL Server 2000
SQL Server 7.0 SP4SQL Server 2000 SP1
SQL Server 2000SQL Server 2000 SP2
SQL Server 2000 SP1
SQL Server 2000 SP2
/Argyle
Good work from Argyle. _________
Satya SKJ
Another option is to open up the package in the Designer, and then save it to a different server, assuming it is compatible. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
]]>