• I had a file that was from a UNIX environment having only the LF character and was comma delimited that I needed to use the 'bcp' command to load into my SQL Server database.  Using the information here was helpful but I thought I'd share the exact syntax I used that made it work specifically for getting a LF only file in.  Specifically I used the command -r0x0A concatenated with the LF character in hex.

    EXECUTE master.dbo.xp_cmdshell 'bcp myDB.dbo.myTable in "C:\myFile.txt" -c -t, -T -r0x0A -SmyServer'