Gopinath Ch
asked on
Not able to insert string from flat file into column with datatype numeric in SSIS .
Tried Data Conversion and other things but string with input column width 15 from flat file is not getting inserted into column having data type numeric(14,4) and length 9 .
000016723440012 ==> In Db the entry should be 1672344.0012....gives error with this data in the specific column
000000000341200 ==> In Db the entry should be 34.1200....works fine with this data in the specific column
.......i used DT_STR while picking it up and then inserting into destination ...then executing an SQL task to update the column using an expression to cast it as numeric ...Generally this works fine except for the former case .
DT_Numeric was not working for me ...only DT_STR with huge output column width was working fine
Error - Conversion failed because the data value overflowed the specified type
000016723440012 ==> In Db the entry should be 1672344.0012....gives error with this data in the specific column
000000000341200 ==> In Db the entry should be 34.1200....works fine with this data in the specific column
.......i used DT_STR while picking it up and then inserting into destination ...then executing an SQL task to update the column using an expression to cast it as numeric ...Generally this works fine except for the former case .
DT_Numeric was not working for me ...only DT_STR with huge output column width was working fine
Error - Conversion failed because the data value overflowed the specified type
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Arifhusen Ansari
As there is no other comments and the solution provided seems good.