This is a good default option. Git will handle the files in whatever way it thinks is best. We'll go over some possible settings below.

But hopefully it helps someone else too! :)First off, within Notepad ++ to see the end of line markers, you need to indicate you want to see them. The automated process expected the end of line markers to be LF to be read by the SSIS package properly.This article will help job my memory when I run across this again. I copied several lines using Notepad ++ and it automatically used CRLF markers. Windows uses both CRLF at the end of a line, whereas Unix uses only a LF.Recently, while troubleshooting why data wont import successfully as part of an automated process, I was pulling a subset of data out of the main text file, but the end of line markers weren't correct. Pythons re module however has End of Line characters include CR or LF. So t+ matches trailing spaces or tabs at the end of each line.

The screenshot below shows what the connection manager will look like for a line ending with LF. This is very easy to use while building the automated process, etc. In the flat file connection manager within SSIS, you will set what the end of the line character(s) are. Click on Search > Replace (or Ctrl + H)This automated process used an SSIS package. In this case, I am replacing CRLF with LF, but you can switch the values and do vice versa easily. We will be using (CR) and (LF) as matching values.

Learning new stuff - quickly and accurately Asking others for Honest Opinions/Feedback DBA Fundamentals Virtual Chapter - January 2019 DBA Fundamentals Virtual Chapter - February 2019

SSIS - Stored Procedures with Return Values How much juice can you squeeze from a lemon? RIP Cursor - took you down from 90 mins to 5 mins

Oracle datetimestamp to SQL Server datetime

Convert Line Endings