sql server - SSIS 2014 issue with currency (Without Decimal) in a flat file source

Question

I am importing data from a flat file to Sql server database. In a flat file data comes without decimal like 3000 for 30.00. I tried setting up this column to DT_Decimal with DataScale 2 or DT_Numeric with precision (12 - 18) and DataScle 2 and I also tried DT_CY Currency. All these are inserting value as 3000.00 in database instead of 30.00. I don't know how to implement this?

Answer 1

I did it with the following steps:

1) Created and opened, an SSIS project

2) Added a dataflow task

3) Created a flat file source

4) Created two step transform:

4a) Data Transformation to a dt_decimal

4b) Derived Column with the Expression: decColumn0 / 100

5) Ole DbDestination