I have solved my issue using the following:
- create a script task that will open my csv files with excel (yes you can do that
) and execute a macro that will replace all the noisy commas (only noisy for the SSIS csv engine) with space.
- open the csv files with the SSIS Flat File Source
- load the csv files in database using Ole DB Destination
Thanks again for your time,