Hi,
A developer just ran into a problem when he is running his data into a target MS SQL Server Load stage...he gets the warning:
cfsstg_finance_database_stage_2_jptest..Cfsstg_finance_database_stage_2_ins.IDENT2: Arithmetic overflow
When he changes the target from the MS SQL Server Load to an ODBC stage with every thing else unchanged he runs clean. I looked at the job and am not sure where IDENT2 is coming from.
Any ideas?
Thanks - - John
Arithmetic overflow into SQl server bulk loader
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 am
Now that one I can't answer. Problems in Server jobs are always reported by the active stage, hence the error from the transformer when the bulk loader went astray. You'd probably need to involve your official support provider if you really wanted to track that one down.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Perhaps the SQL Server loader stage checks the range of unsigned integers as if they were signed, and the ODBC stage doesn't. This is one for your official support provider - that was just a guess on my part. Of course, your job design could ensure that out of range values never reach the stage in the first place.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.