Post reply

Embedded double quotes data from flat file import failing to SQL Server

  • November 19, 2015 at 12:50 pm

    #313240

    Hello everyone,

    I'm posting this question here hoping to find a solution. I have a flat file source which needs to be loaded into SQL Server destination table. The flat file is Pipe demilited and has text qualifier as double quotes (") . But i have a address column which has additional double quotes in it which is causing the failure saying delimiter was not found for column "Address 1".

    Data looks like this

    EMPLID|FIRST_NAME|NickName|MIDDLE_NAME|ADDRESS1|ADDRESS2|

    "00001"|"Jones,David "|"Jones"|"David"|""12310" abc APT #A4"|"6358 gef"|

    Thanks in Advance

  • November 20, 2015 at 5:35 am

    #1841321

    There are different options to solve this problem.

    The easiest would be to change the text qualifier to None in your flat file Connection Manager and use a derived column or a script to strip off leading and trailing double quotes.

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

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