Home Forums SQL Server 2005 SQL Server 2005 Integration Services SSIS and dealing with embedded double quotes RE: SSIS and dealing with embedded double quotes

  • March 9, 2011 at 2:59 am

    #1296379

    natarshia.peck (3/8/2011)

    Hello

    i am running into a similar problem with the embedded double quotes.

    I tried using the redirect row on error to just skip those rows with the double quotes.

    I have not gotten it to work. Does anyone know of a way to just skip over that row and keep processing?

    How exactly is this causing troubles?

    For testing purposes, I loaded a flat file with embedded double quotes into SSIS 2008 and it imports just fine.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP