Replace the comma as our delimiter to the vertical pipe (|) character thus leaving commas intact. Solution for SSIS’s Flat File Connection which does not support alternating text qualifiers. Implemented the solution below to convert extra csv commas to a pipe flat file, now getting an error regarding commas at the end of the file or outside of the delimiters:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |