Data Conversion (SSIS)

The Data Conversion transformation converts the data in an input column to a different data type and then copies it to a new output column.

You can configure the Data Conversion transformation in the following ways:

• Specify the columns that contain the data to convert and the types of data conversions to perform.
• Specify whether the transformation output columns use the quicker, but locale-insensitive, fast parsing routines that Microsoft SQL Server Integration Services provides or the standard locale-sensitive parsing routines. 

http://msdn.microsoft.com/en-us/library/ms141706.aspx