July 8, 2004 at 6:42 pm
Hi Guys,
I am using DTS Import/Export Wizard to copy database from one machine to another. I created a new database on the destination. In 'Specify Table Copy or Query' window, I chose 'Copy obects and data between SQL Server databases'. Error message is 'bulk copy execution failed'. Copy Database Wizard doesn't work either.
How to solve this problem?
Thanks a lot.
July 8, 2004 at 6:59 pm
Is that the complete message or is there a number associated with it?
July 8, 2004 at 7:07 pm
I would also check and make sure that you are not attempting to copy the users/permissions etc... this could cause the DTS package to fail as well...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
July 8, 2004 at 7:13 pm
Hi,
This is a compelte message '[SQL-DMO] The Bulk Copy Execution failed'.
Then AJ Ahrens, how to avoid to copy the users/permissions etc. Where can I more detailed information.
Thanks, thanks again
July 8, 2004 at 7:36 pm
In the copy sql server objects task object UNCHECK "use default options"
UNCHECK the top 3 options (security area).
This may be all you need..
Good Hunting!
AJ Ahrens
webmaster@kritter.net
July 9, 2004 at 8:31 am
hi guys,
It works in the domain and I also tested at home (workgroup). On the workgroup, I can manually do DTS but cannot schedule it. Then I changed SQL Server Agent setting. It works.
Thanks for all replies.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy