Problems w/DTS - simple transfer

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

what is the source data? DBF by chance?

------------
amanda johnson at 7/9/99 2:14:17 PM


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

Sorry, I don't know what DBF means. The source data is a SQL 7.0 accounting database

------------
at 7/9/99 5:21:07 PM


what is the source data? DBF by chance?

------------
amanda johnson at 7/9/99 2:14:17 PM


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

Kind of buggy behavior, isn't it!
Better step away from that Wizard...
Go to DTS and spend a little time writing a Package yourself:
It pays off on the long run.
Best,

Klaus

------------
at 7/9/99 6:03:02 PM


Sorry, I don't know what DBF means. The source data is a SQL 7.0 accounting database

------------
at 7/9/99 5:21:07 PM


what is the source data? DBF by chance?

------------
amanda johnson at 7/9/99 2:14:17 PM


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