SQL 2000 Database Copy Wizard DTS Error

#1

I am trying to setup a database copy DTS package to copy a database from one
server to another. I created the package via the database copy wizard and
everything looks ok.

However when I run the package I get an "Unspecified error" error after a
few minutes.

Does anyone have any suggestions on how I can correct this and get this
process working?

I am running SQL Server 2000 SP3 (source) and SP4 (destination) on Microsoft
Server 2003 Enterprise Edition.

#2

Hello John,

Personally if I was doing this I would use BACK and RESTORE or sp_detach_db
, COPY OVER and sp_attach_db

I find this infinitely quicker and less trouble.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

I am trying to setup a database copy DTS package to copy a database
from one server to another. I created the package via the database
copy wizard and everything looks ok.

However when I run the package I get an "Unspecified error" error
after a few minutes.

Does anyone have any suggestions on how I can correct this and get
this process working?

I am running SQL Server 2000 SP3 (source) and SP4 (destination) on
Microsoft Server 2003 Enterprise Edition.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL 2000 Database Copy Wizard DTS Error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL 2000 Database Copy Wizard DTS Error - 07-24-2006 , 03:00 AM

Re: SQL 2000 Database Copy Wizard DTS Error - 07-24-2006 , 12:59 PM