How to deal with pipe as data in pipe delimited file

Question

I am trying to solve a problem where my csv data looks like below:

A|B|C 
"Jon"|"PR | RP"|"MN"
"Pam | Map"|"Ecom"|"unity"
"What"|"is"this" happening"|"?"

That is, it is pipe delimited and has quotes as text qualifier but it also has pipe and quotes with in the data values. I have already tried

Update based on the comments

I tried to select | as delimiter and " as Text Qualifier but when trying to import data to OLEDB Destination i receive the following error:

couldn't find column delimiter for column B

Answer 1

You have to change the Column Delimiter property to | (vertical bar) and the Text Qualifier property to " within the Flat File Connection Manager

If these is still not working then you have some bad rows in the Flat File Source which you must handle using the Error Output:

• Flat File source Error Output connection in SSIS
• SQL SERVER – SSIS Component Error Outputs