I have a SSIS process which sorts through csv files and text files. Within my process, the source files are within a loop. I have stored procedures that cleans up the data once it is inserted into the database. I have a problem with one of the columns, called “Title”. I noticed that there are times that this column has multiple commas, which means it is not being parsed correctly. I believed it was because as my delimiter is a comma, once the comma is recognized, the data is inserted into its appropriate column. I want all commas stripped from this field. I thought that I could use a derived column within my data flow task, which would actually be from the CSV file source to the derived column and then to the multicast. Is there a way that I can remove all commas from this field before it is inserted into the database? There are thousands of files each day that will be processed.