title: Reading a text file with SSIS with CRLF or LF
body: <p>Running into an issue where I receive a text file that has LF's as the EOL.  Sometimes they send the file with CRLF's as the EOL.  Does anyone have any good ideas on how I can make SSIS use either one as the EOL?  </p>
  
  <p>It's a very easy convert operation with notepad++ to change it to what ever I need, however, it's manual and I want it to be automatic.</p>
  
  <p>Thanks,</p>
  
  <p>EDIT.  I fixed it (but not perfect) by using <a href="http://sourceforge.net/projects/swissfileknife/">Swiss File Knife</a> before the dataflow.</p>