Results 1 to 2 of 2

Thread: DTS Error

  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: DTS Error

    Hi,
    Can any body help me to sort out this problem

    I am running a DTS package source as dbf file and destination as sqlserver database the following error occurs

    for row number 2035 errors encountered so far on this
    task 1. insert error, column 3 ('arch_dt', DB_TYPE DBTIMESTAMP)

    when i was opening dbf file in foxbase its showing (arch_dt field) date as datatype the same when i was importing to access the datatype is changing to text type.

    so daily manually i am opening in excel file and delete the records where the line error occurs.

    in excel file that particular row will have some text format instead of dateformat.

    how can i solve this error without manual interaction..

    with regards
    rajkumar

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    If you insert it as a chracter datatype then you can check the value and correct it.
    You could also probably use an activex script on it but that would be slow.

Posting Permissions

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