I have a csv file with 1 field that requires Quote Qualifier because it contains comma's. Building this into an SSIS package flat file import task. This field also contains extra quotes that I need to import into the field3. Bulk Copy import will have the same issue when separating. Anyone run into this issue? Researching, I could not find much to go on. TIA
Field1,Field2,"This Field3 is all "one" and commas",Field4,Field5