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 am not sure how this will show up after changing the file extension. i wasnt able to upload as .csv

    also, i am not going to be opening up the hundreds of files to edit each instance before running the package. furthermore, the package will be running overnight, pulling the data from the source .csv files that i receive.