We are seeing errors trying to transfer some (most of our db tables ) when using the copy tables option on the wizard (simple transfer, no transformations).

We see an 'error occurred' notation on the Transferring Data dialog - when we click on the individual tables to get a detailed description of the error, we get "General error - -2147217887(80040E21). Errors occurred" notation. We can't figure out what the error was - running a Profiler trace with all events doesn't give us any clues. If there is a DTS log (similar to the old Transfer Manager log), we can't find it....

Interestingly, we get the same error number for all errant tables and the error isn't always consistent - tables that didn't work yesterday do work today, but new ones are erring...


Any info would be greatly appreciated... Many thanks