Brad Allison wrote:
What is the best practice in SSIS to handle that situation?
Tell your connection manager your text is Quote Identified (with the
" character); it's an simple as that. Then a string like:
1,31/01/2019,"Steve, went to the shops" would be read as 3 different values,
Steve, went to the shops. The
, in the last value won't be perceived as a delimiter, as it's inside the text qualifiers.
It really is that simple.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.