Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Unanswered: dts conversion error

    I have a dts package that imports data from a comma delimited .csv file.

    I'm getting a conversion invalid for datatypes on column pair 1 (source 'col0012' (DBTYPE_STR), destination column 'latitude' (DBTYPE_R8)).

    So, the source file is populated as a string for 'col002' and I have that field specified as a float within my table. Float is the correct type for the value.

    How can I make the conversion correctly during the dts execution.

    Thank you.

  2. #2
    Join Date
    Nov 2004
    on the wrong server
    Provided Answers: 6
    do you have any empty strings in the source file going to the float column?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Feb 2004
    One Flump in One Place
    Also - does your CSV include column headings and, if so, have you ticked the box in the DTS to let SQL Server know that?
    pootle flump
    ur codings are working excelent.

Posting Permissions

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