Problem with Importing flat files with embedded (CR)(LF) characters.

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  August 4, 2015 at 2:57 pm

  #1817332

  Script tasks ARE fun but it shouldn't be necessary. SSIS should be able to handle the problem just fine if the text qualifier is enabled.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• kingdonshel

  SSCommitted

  Points: 1704

  More actions

  August 5, 2015 at 3:51 am

  #1817416

  I am really not big on scrpting guys I think I would still need to provide a column delimiter, to the scrpt. I am working with a comma delimited file that has tripple quotes around the last column which is the Comments column. This column has the hidden characters which causes the problem.

  I have already mentioned that I have set the text qualifiers to both True and False on the connection manager and it still did not work.

  Could anyone suggest where I could fina script to overcome this problem since I think this might be the only solution. I don't find scripts to be fun since I am not savvy with scripting languages.

• gregdavis11009

  Newbie

  Points: 1

  More actions

  July 31, 2019 at 3:10 pm

  #3667581

  I have the same problem with an LF character embedded inside a quoted field header from a CMS data file download.  If I figure something out, I'll post back.  SSIS is not as forgiving as other data import software (it can be a real pain in the @ss sometimes).