Arithmetic overflow into SQl server bulk loader
Posted: Fri Mar 25, 2011 7:31 pm
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
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