July 28, 2004 at 11:47 am
I'm attempting to run a DTS package that simply copies objects from a production server to a dev server and the package keeps failing. All I'm getting in the log is:
Step Error Source: Microsoft SQL-DMO
Step Error Description:[SQL-DMO]The Bulk Copy execution failed.
Step Error code: 80045707
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131
I admit I'm still new to SQL Server but this information doesn't seem to be very helpful. How can I find out what's really causing my package to fail?
July 28, 2004 at 11:56 am
It sounds like the server and databases are the same names and that is causing problems. You need to use collation to fix, if this is the problem.
Just a guess!
August 1, 2007 at 6:36 am
it works after I checked on the DROP DESTINATION OBJECTS FIRST and USE COLLATION boxes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply