-
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
-
Problems w/DTS - simple transfer (reply)
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
-
Problems w/DTS - simple transfer (reply)
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
-
Problems w/DTS - simple transfer (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|