July 22, 2006 at 9:46 am
I have been working creating a load process from data produced in MSSQL to a DB2 database, another system wants this data for their processing. Keep running into an error that reads: The number of failing rows exceeds the maximum specified.
Reviewed all of the field mappings and none of the data seems to be causing this. Even tried it using a simple SELECT of string values and it still fails.
Any ideas would be great. Thanks
July 25, 2006 at 10:48 am
Are you using a data transformation task? If so, have it write an exceptions file. Open the transformation task, go to the Options tab, and enter a path in the Exception File Name box. This file will tell you what is causing the transformation to fail.
July 25, 2006 at 9:32 pm
Thanks. Actually I did find out that there is a know problem from one of DB2 DBA I work with and that they are working on the issue. Has to do with a couple of things, one is the version of the DB2 client in use, they are having me move to DB2Connect, v8, fp10.
Some other recommendations
1) set up in your Configuration Assistant using asyncenable = no
2) in the setting of the ODBC Data Source Administrator, under the System DSN tab, find IBM DB2 ODBC DRIVER. Make sure that connection pooling is disabled. Connection pooling is OK if only doing odbc.
If doing oledb - odbc bridge, this is 2 types of pooling and depricates the transaction
3) be sure the package we're using is using the OLE-DB driver
proper driver to use is:
ibmdadb2
on the dts package
don't use msdasql in the dts package setting
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply