Hi,
There is no numeric data type for SSIS Variables that directly maps to DT_NUMERIC. Therefore, you could use one of the available numeric data types such as Int32, Int64 (which are integers) or Single and Double (which are floating point).
But you have to first check on the precision and the scale of the original numeric variable in order to chose the appropriate SSIS Variable data type. For example, if the scale is 0, then an integer variable might suit your need, else you may choose a floating point data type. Again you would have to check on the precision to see how big the variable has to be Int64 or Double for a bigger data. Refer Books Online for data type capacities.
You may sometimes run into problems if the numeric data type is of a size larger than what the available SSIS Variables types can handle.
Regards
Gogula G. Aryalingam (MVP - SQL Server)
