troubleshooting Question

Not able to insert string from flat file into column with datatype numeric in SSIS .

Avatar of Gopinath Ch
Gopinath Ch asked on
SSISSQL* Datatype
2 Comments1 Solution156 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Arifhusen Ansari
Business Intelligence Developer and Analyst
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros