So why use one over the other? Well the Data Conversion transformation will just take an input, convert the type and provide a new output column. If you use the Derived Column transformation you ...

Data Conversion in SSIS Data conversion transformation or derived column transformation? It depends and you've also got other options. By Eric Johnson 08/31/2010 When it comes to converting data ...