August 16, 2014 at 5:46 pm
I've a CSV file as source going to OLEDB Destination (SQL table)
Row delimiter is CRLF
Text Qualifier is "
Issue is some data value inside itself contains " to represent inches. For example 2" X 3"X 10" in Extra Description column.
hence the error
[Flat File Source [1]] Error: The column delimiter for column "Extra Description" was not found.
Anyway to clean this up?
If not, I just want to skip these rows and I set up Redirect Error to a file but it always fails on these value and I don't get anything in the error file and the package fails when it encounters errorneous rows. Any idea why I'm not able to redirect my error into a file?
August 16, 2014 at 11:05 pm
SQL_Surfer (8/16/2014)
I've a CSV file as source going to OLEDB Destination (SQL table)Row delimiter is CRLF
Text Qualifier is "
Issue is some data value inside itself contains " to represent inches. For example 2" X 3"X 10" in Extra Description column.
hence the error
[Flat File Source [1]] Error: The column delimiter for column "Extra Description" was not found.
Anyway to clean this up?
If not, I just want to skip these rows and I set up Redirect Error to a file but it always fails on these value and I don't get anything in the error file and the package fails when it encounters errorneous rows. Any idea why I'm not able to redirect my error into a file?
Quick questions, where does the CSV files come from? Can the CSV files be produced to comply with RFC 4180?
The underlying error is that double quote characters inside a quoted text must be escaped by a double quote character.
😎
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply