errolthomasql (8/27/2014)
i am not sure how this will show up after changing the file extension. i wasnt able to upload as .csvalso, 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.
Point taken;-)
Another suggestion, use a derived column to add a sign column for each of the value columns, assign -1 if the value column has the parenthesis and 1 if it hasn't. In the same derived column, simply remove the parentheses from the values and convert the column to numeric.
Alternative would be import the whole thing into a staging table and manipulate it in T-SQL.
😎