Home Forums Data Warehousing Integration Services SSIS 2012 - Double quote charcter in data does not allow to load flat file to source component. RE: SSIS 2012 - Double quote charcter in data does not allow to load flat file to source component.

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