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 - 2003-05-12 : 06:54:40
|
| Scott writes "Help needed on moving our SQL database to a new server.I tried to move our SQL server to a new machine but I had a problem with the DTS designer when trying to open up a package. The Errors that came up were:1) DTS Designer Error - "Error in the DLL"2) Package Error - "Need to run the object to perform this operation"3) DTS Designer Error - "The selected package cannot be opened. The DTS designer has been closed"A similar error also came up when trying to use the DTS Import or Export Wizard.The process I used to move over the SQL machine was this:1) Copy entire SQL2000 folder and other folders containing the data and logs to the new machine.2) Take old server off the network.3) Change name of new server to same as old server and get on the network. Install SQL Server 2000, put same Service Pack on.4) Delete the new SQL folder created by install and all sub folders and copy over the old SQL2000 folder into the correct path as well as all the data / log folders.5)Restart SQL Server, confirmed All databases intact with all users / logins etc, confirmed that I can connect to applications accross the network.Everything was looking good at this point until I tried to view the packages. when I came up with the above errors.I unregistered then re-registered the following DTS dll's dtsffile.dlldtspkg.dlldtspump.dllaxscphst.dllcuttask.dllstill no joy......Any help on this would be greatly appreciated as I had to roll back the upgrade and put the old server back on the network.One thing to bear in mind is that the Old SQL Server is on Windows NT and the New SQL is now Windows 2000 server. Could this be causing a problem ?Thanking you in advance" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-05-12 : 07:10:23
|
| I didn't see the part of you process where you installed sql server on the new machine ... did you?Also, are there any custom tasks (.dlls) in your pkgs?Jay White{0} |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-12 : 12:05:39
|
| And even if (or when) you've installed SQL Server, why not do a dump and restore (or attach?)It seems like going to the corner store by way of Hong Kong?Brett8-) |
|
|
|
|
|
|
Moving SQL to new machine