Post reply

SSIS Double quote text qualifiers

  • December 12, 2014 at 6:32 am

    #397772

    We have an issue with importing a CSV file into SQL where using a double quote " text qualifier is failing. The data is correct but it fails on a particular line, complaining about the qualifier even though the qualifier is in place and previous lines have imported fine.

    Has anyone seen this before? I will post sample data if it will help

  • December 12, 2014 at 8:11 am

    #1764436

    Hi,

    It will be great if you can post some sample and the desired output you need.

    Cheers

  • December 12, 2014 at 8:16 am

    #1764439

    What's the actual error message?

    We had problems importing files using ~ as a separator because one of the records had a ~ in the text itself. This knocked everything out of kilter and led to error messages.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • December 12, 2014 at 8:21 am

    #1764443

    Welcome to the joy of working with text files, someone entered your text qualifier in one of the fields and that's throwing off your import routine. You'll have to go through the line that's causing the error in detail and chances are you'll find an offending column.

    A relatively quick way to check is to open a good line and the bad line in excel and see if the bad line has an extra column in it.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply