Upgrade database from SQL 7 to SQL 2000 DTS unspecified error

[Dale3]

In trying to use the upgrade wizard to convert a database from SQL 7 to SQL 2000 (remote server to local server) I receive the error: Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error

Step Error code: 80004005
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

This error is preceded by the error number 2747467259. I have tried this on several different databases and receive the same error one each one. I receive the exact same error on three steps of the wizard: CDW Logins Task, CDW MSDB TAsk and CDW Databases task. The CDW Master task and CDW errors task finish without error.

Any ideas?
Thanks

 

[MeanGreen]

What Service packs do you have on each SQL Server? Are you using Named Pipes or TCP/IP?

 

[Dale3]

On the destination server: Win2K SP3, SQL 2000 SP2
On the source server: Win2K SP2, SQL 7.00.842
TCP/IP

 

[Dale3]

On the destination server: Win2K SP3, SQL 2000 SP2
On the source server: Win2K SP2, SQL 7.00.842
TCP/IP