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

  • errolthomasql (8/28/2014)


    since i cant change the data type for existing columns in the Derived Column transformation

    We cann't change the data type for existing columns but you can always use the <add as new column> instead of replace in the derived column transformation.