ssis csv file ragged right fromat w " text qualifier

Question

[![I'm importing csv files in ssis that are in a ragged right format, I've been able to create the columns perfectly fine but for some of the data rows it has included a " text qualifier into the data in the first column which makes the character count of each column out sync and pushes some characters over to the next columns, the " text qualifier is also found in the last column of the same row by itself instead of the value being blank. These " text qualifiers are also not found in the original csv file, the flat file connection manager also does not let you use the text qualifier option when working with ragged right so i can't take them out that way.

]1]1

question from:https://stackoverflow.com/questions/65894612/ssis-csv-file-ragged-right-fromat-w-text-qualifier

Answer 1

Waitting for answers