using SSIS 2012. My flat file connection manager I have a delimited file where the row delimiter is set to CRLF
, but when it processes the file, I have a text column that has an LF
in it. This is causing it to read that as a row terminator causing it fail. Any ideas?
{CR} The header row is delimited by a carriage return. {LF} The header row is delimited by a line feed.
Select the connection manager in the Connection managers bar. Go to the Properties Pane and find the "expressions" option. Click the ellipsis in the adjacent blank window to open a new window. Find "File Name" or "Connection String" in the drop down, and then in the expression, put the name of your variable.
I have no SSIS experience but as an ETL developer I have faced this many times. So my suggestions might not help you solve the problem but hopefully point you in the right direction
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With