Post reply

Removing noisi commas in CSV file (SSIS)

  • 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.

  • 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

  • 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

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply