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.