Copy Database Wizard Problems

Hi,
I am trying to use the copy database wizard to copy a database from SQL
server 2000 to SQL Server 2005 on the same machine. When I run it, it fails
on the create package step with error message "Error loading type
library/DLL". The first two steps (Add log for package and add tasks for
transfering database objects) are sucessful. What does this error message
means? How can I correct it?
Thanks,
JimHello Jim,
I would like to know more detailed information about your environment so
that I can provide more troubleshoot steps.
1. What's your OS version and SQL Server version?
2. Have you applied latest Service pack for the Sql server and Windows OS?
3. Are you using the 64bit OS?
I would also like for you to check if the following registry key is present
or
not. If so please export it and send it to me:
HKCR\Wow6432Node\ " "
In here search for a key with TypeLib GUID ={D1D9A51E-B4FE-420B-97B1-28A383EF9168} >
If the key is present proceed to try registering the dlls below as
follows.
PLEASE PERFORM IN THE ORDER SPECIFIED:
Regsvr32 /u "C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\DTS.dll"
Regsvr32 /u "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll"
Regsvr32 "C:\Program Files (x86)\Microsoft SQL
Server\90\DTS\Binn\DTS.dll"
Regsvr32 "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll"
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Jim
I assume this is from SQL 2000 to SQL 2005, have you tried running this from
SQL 2005 instead. Will the same thing happen if you save this as a package
and then run the package?
John
"Jim Zhao" wrote:
> Hi,
> I am trying to use the copy database wizard to copy a database from SQL
> server 2000 to SQL Server 2005 on the same machine. When I run it, it fails
> on the create package step with error message "Error loading type
> library/DLL". The first two steps (Add log for package and add tasks for
> transfering database objects) are sucessful. What does this error message
> means? How can I correct it?
> Thanks,
> Jim|||Hi
If using SQL 2005 this may help! http://support.microsoft.com/kb/918222/
John
"John Bell" wrote:
> Hi Jim
> I assume this is from SQL 2000 to SQL 2005, have you tried running this from
> SQL 2005 instead. Will the same thing happen if you save this as a package
> and then run the package?
> John
> "Jim Zhao" wrote:
> > Hi,
> >
> > I am trying to use the copy database wizard to copy a database from SQL
> > server 2000 to SQL Server 2005 on the same machine. When I run it, it fails
> > on the create package step with error message "Error loading type
> > library/DLL". The first two steps (Add log for package and add tasks for
> > transfering database objects) are sucessful. What does this error message
> > means? How can I correct it?
> >
> > Thanks,
> > Jim|||Jim Zhao wrote:
> Hi,
> I am trying to use the copy database wizard to copy a database from SQL
> server 2000 to SQL Server 2005 on the same machine. When I run it, it fails
> on the create package step with error message "Error loading type
> library/DLL". The first two steps (Add log for package and add tasks for
> transfering database objects) are sucessful. What does this error message
> means? How can I correct it?
> Thanks,
> Jim
You might consider doing yourself a favor by doing a backup/restore to
"copy" your database, instead of using this wizard... Easier, faster,
and you can TROUBLESHOOT it if it doesn't work...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.sqlsql