Post reply

Staging Flat file with Quotes as Text Qualifier

  • July 13, 2009 at 10:47 am

    #133753

    Hey Guys,

    I am using bulk-insert command to stage flat files delmited with comma or pipe with quotes as text qualifier... the problem is the text qualifier.... is there anything that I can use in bulk-insert as the parameter that can ignore those quotes when staging the data? I am sure lot of people have been asking this... sorry. This will be an automated process and we will not be using SSIS or DTS for staging.

  • July 13, 2009 at 12:39 pm

    #1024094

    Problem is we cannot create format file that easily as every file can have different number of fields in it.

  • July 13, 2009 at 3:32 pm

    #1024159

    First row has column name...

  • July 13, 2009 at 3:40 pm

    #1024164

    KeyCode, MemAcctNum, NATitle, NName

    205509,0505488528,,"Rip, Winkle"

    205501,0505488111,,"Tiger, Scott"

    Sample data.

    Quotes only for fields that has embedded comma.

  • July 13, 2009 at 10:34 pm

    #1024235

    Ghanta,

    Please try the solution suggested by Sergiy at http://www.sqlservercentral.com/Forums/Topic18289-8-2.aspx

    It works for me.

    Manu

  • July 14, 2009 at 9:21 am

    #1024488

    Manu,

    Thanks for the link... solution there should help...

    Actually I have the same problem as the person in that thread had. The quotes will be there for only fields that has embedded comma. I will cehck that thread.

Viewing 6 posts - 1 through 5 (of 5 total)

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