Awesome! Thanks so much for that lead.
My import progam is a VB.NET console app that also has a User Interface component option should a human decide to run it manually for any reason. While C# is not my forte I can modify the code if necessary. If it's just a matter of referencing the C# assembly then that's even better.
Even if you change the delimiter to pipe making your example line look like this, SSIS still will not rid your data of the doubled double-quotes.
I had planned on dealing with those when moving the data from the staging tables into the production tables. I will be bypassing SSIS altogether...again.
After looking at the FileHelpers website, it appears to be just what the Doctor ordered.
You have made my day! I should be out of the woods by Monday and offering my customers the new data import progam shortly afterwards.
Thanks muchly 🙂