Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS package execution issues

Author  Topic 

HRSVKE
Starting Member

1 Post

Posted - 2013-12-12 : 01:54:44
Hi Everyone!!

I am having issues while executing the SSIS package.I am loading the data from one database to other database.I tried executing the package but failed at the data flow due to Error code: 0x80004005
: Arithmetic over flow converting numeric to data type numeric. Data flow contains one database table as source, derived column and 2nd database table as destination.The columns in both the tables have same datatype but different sizes.
I tried to modify the size of the i/o columns but did not find the solution yet.Is there any issue with the size of the i/o columns or is it related to any other issue do I need to look into. I am kinda stuck, Can any one help me in resolving this issue.


Thanks for your help in advance!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-12 : 11:57:09
You need to make sure destination column will have precision and scale value which is high enough to hold data coming from source. If its a table storing aggregated values its precision should be higher than precision of source field(s)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -