Job aborts when array size and record count is set to 65000
Posted: Wed Oct 09, 2013 8:22 am
Hi All,
We get the error and the job aborts when array size and record count is set to 65000 on ODBC stage-Insert Bulk failed due to schema change on target table.
Observation - new nullable columns are added to the table after we developed the job. These new columns are not defined in the job but as they are nullable, the job was working fine until recently when the array size was set to 1. But when we changed the array size to 65000 to improve the performance, the job gets aborted if we don't define those new nullable columns in the job
Thanks in advance.
We get the error and the job aborts when array size and record count is set to 65000 on ODBC stage-Insert Bulk failed due to schema change on target table.
Observation - new nullable columns are added to the table after we developed the job. These new columns are not defined in the job but as they are nullable, the job was working fine until recently when the array size was set to 1. But when we changed the array size to 65000 to improve the performance, the job gets aborted if we don't define those new nullable columns in the job
Thanks in advance.