title: Flat file connection manager carriage return/line feed discrepancy
body: <p>I'm upgrading from SQL Server 2008R2 to 2017, and making the same jump with SSIS. There are a number of flat file imports that are picking up files that have carriage return/line feeds (<code>{CR}{LF}</code>) embedded within a column in the row.</p>
  
  <p>The 2008R2 flat file connection manager ignores the embedded <code>{CR}{LF}</code>s that are within a row, but the flat file connection manager in 2017 is treating each <code>{CR}{LF}</code> as a new line. It's the same in an upgraded connection manager or a brand new one that I make from scratch.</p>
  
  <p>In both versions, the connection managers have the same specs: </p>
  
  <pre><code>General Tab
  
    Locale: English (United States)
    Unicode: No
    Code page: 1252 (ANSI-Latin I)
    Format: Delimited
    Text qualifier: &lt;none&gt;
    Header row delimiter: {CR}{LF}
    Header rows to skip: 0
    Column names in the first data row: Check
  
  Columns Tab
  
    Row delimiter: {CR}{LF}
    Column delimiter: Vertical Bar{|}
  </code></pre>
  
  <p>The not particularly complicated text file I'm testing with:</p>
  
  <pre><code>row_id|row_data|empty_column|created_by|one_more_field{CR}{LF}
  1|random test data||ebrandt|{CR}{LF}
  2|Data field with a carriage return{CR}{LF}
  and a line feed embedded in it.||ebrandt|
  </code></pre>
  
  <p>I pasted on the line terminators, just to show that they're there.</p>
  
  <p>On the <code>Columns</code> tab, the Preview window in BIDS 2008R2 shows two rows:</p>
  
  <p><a href="https://i.stack.imgur.com/o2DAV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o2DAV.png" alt="2008R2_connectionmgr"></a></p>
  
  <p>But in 2017, exactly the same file gets broken into three rows:</p>
  
  <p><a href="https://i.stack.imgur.com/Nwr1l.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Nwr1l.png" alt="2017_connectionmgr"></a></p>
  
  <p>There isn't bandwidth in this project to rework all the file imports. </p>
  
  <p>Is there a setting that got changed between versions that I can change back? Or is there another trick to this that I'm missing? </p>
  
  <p><strong>Edit:</strong> In response to a comment that's been deleted, I would specify a text qualifier if I could, but the files I'm getting don't have any. </p>