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

  • I also like the derived column idea.

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

    Replace '(' with '-' (minus)

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.