I'm trying to import a comma delimited text file into a SQL table-
The row delimiters I am assuming are {CR}{LF}
When I try to open up my file in Excel, the data file parses perfectly.
When I try to port it over in SSIS, I get an error:
"The column delimeter for column <my column> was not found."
"An error occurred while processing the file <my file> on data row 2076"
I've tried looking at that data row, and i am having a hard time finding anything wrong with the row.
Anybody know of any good ways to debug that?
n/m- I figured out my problem- the data was buggy- it had dual double-quotations- yet the double-quotations are what signified text qualifiers- and SSIS was not correctly picking up the text qualifiers correctly.
How do you get SSIS to understand quotes if the text qualifier is a quote?
No comments:
Post a Comment