Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: DTS Import error on CkDate

    Im trying to import a tbl from access why am i getting this msg?

    Error at destination for row #58

    Insert error, colm 6 ('Check Date, dbtype_dbtimestamp), status 6: Data over flow.
    Invalid character value for cast specification.

  2. #2
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool DTS Import error on CkDate

    Please look in Access at row 58 and see what the illegal character is. Use the dts to clean the data as it come in.

    Take a look aWarning: Non-existent step referenced by
    @on_success_step_id.
    attachment as see what these errors are?????

    Warning: Non-existent step referenced by @on_success_step_id.
    Warning: Non-existent step referenced by @on_success_step_id.
    Warning: Non-existent step referenced by @on_success_step_id.
    Warning: Non-existent step referenced by @on_success_step_id.

    Thanks
    Attached Files Attached Files

  3. #3
    Join Date
    Oct 2003
    Posts
    311
    The data in row 58 for check date is a regular date


    I dont understand what your saying about :

    Take a look aWarning: Non-existent step referenced by
    @on_success_step_id.


    or how to transform data from dts

  4. #4
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Specifically, what do you have set in SQL Server as the datatype for your date/time column?

    Can you show us several rows that you're attempting to import, including the one that failed?
    That which does not kill me postpones the inevitable.

  5. #5
    Join Date
    Oct 2003
    Posts
    311
    I was trying to use datetime as the colm type. I end up with no rows in my table and all the rows in my access tbl are the same format :


    Date_Entered Initials Vendor Name CheckNum Type ChkDate ChkAmt
    11/19/02 ns 21' Club Inc. 1083 Meal 10/16/02 1,170.59
    11/15/02 ns 21' Club Inc. 1091 Meal 11/12/02 1,634.68

  6. #6
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    how are the delimited during your import? Tabs?
    That which does not kill me postpones the inevitable.

  7. #7
    Join Date
    Oct 2003
    Posts
    311
    I was just using Dts wizard import from an access database.

  8. #8
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Just a thought.. make a backup of your MDB, pull out all the rows but one and see if it imports ok. Then try this again with the row #58 row and see if it goes through or bombs again.
    That which does not kill me postpones the inevitable.

Posting Permissions

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