Post reply

bulk copy execution failed when using DTS Import/Export Wizard

  • July 8, 2004 at 6:42 pm

    #63410

    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

    #513938

    Is that the complete message or is there a number associated with it?

  • July 8, 2004 at 7:07 pm

    #513940

    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

    #513942

    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

    #513946

    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

    #514096

    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 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply