Post reply

When delimiter is part of the field - How to handle in SSIS

  • March 13, 2013 at 12:43 am

    #275157

    I have a CSV file with field delimiter as COMMA (,). The package is working without any issues for few source files, but fails when the field value in the file contains “COMMA”.

    Note: I have no control over source file. Is there a way to handle it in SSIS?

    [font="Calibri"]Raj[/font]

  • March 13, 2013 at 1:15 am

    #1596379

    dfine (3/13/2013)

    I have a CSV file with field delimiter as COMMA (,). The package is working without any issues for few source files, but fails when the field value in the file contains “COMMA”.

    Note: I have no control over source file. Is there a way to handle it in SSIS?

    I am not sure ... but, an option would be to route the failed row to a flat file destination.. and you can clean the data afterwards...

    it the delimiter is "," and the data can have commas , then it's not the correct delimiter after all ..

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

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

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