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 3:07 am

    #1817048

    kingdonshel (8/4/2015)

    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.

    It's been a long time since I used 2005, so this may not be possible for you, but in 2014, you can set the overall text qualifier for the file and then, for each column (in the 'Advanced' node) you can set the 'TextQualified' property to true or false.

    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.