I am trying to insert some data into a SQL Server table. One of the columns is a VARCHAR column with the possiblity of having some carriage return and line feed characters. The problem is that on a line that ends with a backslash followed by the carriage return and line feed characters, the backslash is being truncated. How can I preserve the backslash character?

Here is a sample. Note the "crlf" characters are the actual carriage return and line feed characters, not acutal "c" "r" "l" "f" characters.

Source:

This is a test\crlf
This is the second line.

The actual data after insert:

This is a test
This is the second line.