Avatar of Gopinath Ch
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
SQLSSIS* Datatype

Avatar of undefined
Last Comment
Arifhusen Ansari

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Arifhusen Ansari

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Arifhusen Ansari

As there is no other comments and the solution provided seems good.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck