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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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!

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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