Home Forums Data Warehousing Integration Services failing to convert numbers in parenthesis within a CSV file, to a SQL database as negative numbers, via SSIS RE: failing to convert numbers in parenthesis within a CSV file, to a SQL database as negative numbers, via SSIS

  • August 28, 2014 at 1:51 am

    #1741558

    I also like the derived column idea.

    Replace ')' with '' (empty string).

    Replace '(' with '-' (minus)