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.
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
SSIS package execution issues