Results 1 to 2 of 2

Thread: DTS error

  1. #1
    Join Date
    Jun 2004
    Posts
    19

    Unanswered: DTS error

    Hi,

    I am transferring data from sybase to MS Sql server(using DTS) and it transferred all the tables correcty except for one table for which it says

    error at destination rownumber 20. Errors encountered so far in this task 1,
    Insert error column 36(last_purchase_date,dbtype_dbtimestamp)status 6, dataoverflow invalid character value for cast speicification

    Can you please tell what cud be causing this error and how cud we get rid of it.

    Thanks & Regards

  2. #2
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    It might be a data error...switch off the fast load option for this and try doing it with error logging on and see what comes out in the log file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •