Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-02 : 07:25:38
|
| Steve writes "Is it possible to move a DTS package from a SQL 7.0 server to another SQL 7.0 server. The Servers are on different domains the old one being Windows NT and the new one Windows 2000." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-02 : 07:27:10
|
| Yes, this is pretty easy. Open the package in Design view, choose Save As, then select the server you'd like to save the package to.Alternately, you can save the package as a Structured Storage file, open the new server, right-click the Data Transformation Services item, then select Open Package. You then open the structured file, then do Save As again to save it to SQL Server. |
 |
|
|
|
|
|
SQL 7.0 Move DTS package to another SQL 7.0 Server