Results 1 to 4 of 4

Thread: Problems w/DTS - simple transfer

  1. #1
    amanda johnson Guest

    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

  2. #2
    Guest

    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

  3. #3
    Guest

    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

  4. #4
    Klaus Guest

    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
  •