Monday, March 12, 2012

Package "ShellPackage" failed for Copy Database


I'm trying to migrate a SQL 2000 database to SQL 2005. I'm using the Copy Database Wizard and can copy the database using the detach and attach method, but I would rather use the SQL Management Object method. I get the following error when trying to use this method:

Package "ShellPackage" failed.

This error occurs directly after the following step:

Event Name: OnInformation
Message: Transferring data to database RestoreTest from RestoreTest
Operator: <WAN\first.lastname>
Source Name: BP-BLM-TESTSQL2_BLM-JCAMPVSSQL2_Transfer Objects Task
Source ID: {E6765B9E-1B40-49ED-B0CE-F99252AA34B6}
Execution ID: {213272C4-37E9-4A1E-A5B9-A2F9A61348B3}
Start Time: 12/20/2005 3:05:58 PM
End Time: 12/20/2005 3:05:58 PM
Data Code: 0

The database is created successfully but the data is not transfered. Also, the logins are created on the new server successfully. Has anyone seen this error or have any ideas on how to solve this problem? I would greatly appreciate any help!



This is occurring for us as well.

I am assuming it is some sort of perms problem... anyone else?

|||Um, Me too. It's amazing how long I've been working on this
I'm getting the shellPackage failed in the event log and this in the text log
"Could not find server 'serv4' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

No comments:

Post a Comment