There have been some posts on the difficulties of handling csv with quoted identifers.
I heard there were some custom components that aid in dealing with these as input files.
IYO, what do you consider to be the best way to deal with csv with quoted identifiers as an input to an ETL operation?
Also, if you know of any bloggers making quality (hopefully free) custom components?
Thanks!!
Personally, I've found the easiest way is to use a genuine CSV Reader,which handles all the special cases that SSIS does not. Make a Script Source Component using it. See http://www.csvreader.com/, or for a free version, try http://www.codeproject.com/cs/database/CsvReader.asp.
No comments:
Post a Comment