Post reply

SSIS 2012 - Double quote charcter in data does not allow to load flat file to source component.

  • April 10, 2015 at 8:56 am

    #150876

    Hello everyone,

    I've created a source component for flat file data.

    This file contains data the column data in double quotes. Like,

    First Name Last Name

    "Ankit" "Shah"

    The text qualifier is double quote for source file connection.

    When I do have data like below, it does not able to load the source file. And throws an error "The column delimiter for column was not found"

    First Name Last Name

    "Ank"it" "Shah"

    Can anybody please advise how to resolve this problem?

    Any help would be much appreciated.

    Thanks,

    Ankit

  • April 10, 2015 at 9:20 am

    #1790212

    Can anybody please advise how to resolve this problem?

    Change your text qualifier to something else.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 10, 2015 at 11:06 am

    #1790244

    Hello Phil,

    Seems like you are trying to tell the following solution.

    http://visakhm.blogspot.in/2014/06/ssis-tips-handling-embedded-text.html

    Actually I tried to achieve it but the replace expression is throwing an error. It does not allow me to have that expression.

    Thanks,

    Ankit

  • April 13, 2015 at 3:57 am

    #1790455

    ankithimmatlalshah (4/10/2015)

    Hello Phil,

    Seems like you are trying to tell the following solution.

    http://visakhm.blogspot.in/2014/06/ssis-tips-handling-embedded-text.html

    Actually I tried to achieve it but the replace expression is throwing an error. It does not allow me to have that expression.

    Thanks,

    Ankit

    Actually that is not what I was suggesting.

    (Potentially) The easiest solution is to speak to the person who created the file, explain the embedded quotes issue and ask them to produce another version of the file which uses a pipe (|) or some other unusual character as a delimiter.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 13, 2015 at 4:22 am

    #1790458

    Hello Phill,

    Thank you for the response.

    I've finally managed it with script component, wherein I replaced the column separator with vertical pipe and row separator as TAB character and managed to load the complete data file to Flat file source component.

    Following link has helped me a lot while resolving this problem.

    http://geekswithblogs.net/Compudicted/archive/2011/09/19/ssis-how-to-remove-occasional-quotes-and-replace-the-column.aspx

    Thanks,

    Ankit

  • April 13, 2015 at 4:27 am

    #1790459

    ankithimmatlalshah (4/13/2015)

    Hello Phill,

    Thank you for the response.

    I've finally managed it with script component, wherein I replaced the column separator with vertical pipe and row separator as TAB character and managed to load the complete data file to Flat file source component.

    Following link has helped me a lot while resolving this problem.

    http://geekswithblogs.net/Compudicted/archive/2011/09/19/ssis-how-to-remove-occasional-quotes-and-replace-the-column.aspx

    Thanks,

    Ankit

    Well done. But a lot of work!

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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