Home Forums SQL Server 2005 SQL Server 2005 General Discussion Removing commas and quotes from numeric fields in csv file using SSIS RE: Removing commas and quotes from numeric fields in csv file using SSIS

  • January 11, 2012 at 6:24 pm

    #1432240

    Thank you all for replying.

    Making the following changes solved the issue:

    1. Setting Text Qualifier of Flat File Connection Manager to ".

    2. Using REPLACE(REPLACE(Column,",",""),"\"","") in Derived Column Transformation.