Removing noisi commas in CSV file (SSIS)

• damien.gulluni

  Say Hey Kid

  Points: 671

  More actions

  October 7, 2013 at 3:01 am

  #1656264

  You can open csv in excel and I obviously know the difference between excel and csv files.

  I don't think that using StreamReader class will help me a lot.

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  October 7, 2013 at 3:04 am

  #1656266

  The first 1100+ rows are loaded with no errors. Can you please analyze the issue with the row(s) which are failing?

  Raunak J

• damien.gulluni

  Say Hey Kid

  Points: 671

  More actions

  October 8, 2013 at 5:57 am

  #1656688

  Hi,

  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,

  Regards,

  Damien