[Solved] SSIS 2014 issue with currency (Without Decimal) in a flat file source

by


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

1

solved SSIS 2014 issue with currency (Without Decimal) in a flat file source