Home Forums SQL Server 2005 SQL Server 2005 Integration Services Problem with Importing flat files with embedded (CR)(LF) characters. RE: Problem with Importing flat files with embedded (CR)(LF) characters.

  • August 4, 2015 at 2:11 am

    #1817025

    Actually no I have not used the """" quotes as a text qualifier, the reason for this is that only the Comments column has the double quotes, the other columns in the text file don't. Also the Header Row for the file is not double quoted only the text under the Comments columns is.

    in SSIS you can only set a Text qualifier for the Header Row and in this case its not needed.