可以在SSIS中使用强制转换，请参见: ^ ]

Could you use cast in SSIS, see: http://msdn.microsoft.com/en-us/library/ms141704(v=SQL.90).aspx[^]

尝试以下操作:
将十进制和日期/日期时间类型转换为自定义类型varchar等效项
将SQL Server数据类型映射为Integration Services数据类型

Try following:
Conversion of decimal and date/datetime types into custom varchar equivalents
Mapping of SQL Server data types to Integration Services Data Type