Transactions against AS 400 -
09-07-2005
, 07:50 AM
Hi,
I'm using SQL Server 2000 DTSs to insert data in AS 400 files (trhough a
Data Transaformation Task).
I'm using IBM Client Access Express OBDC Drivers to do it. The DTS works
fine when Transactions are disabled but it doesn't insert any data when
transactions are enabled.
When I try to insert data within a transaction (a MSDTC transaction managed
automatically by DTSs), I receive this error:
Step 'DTSStep_DTSDataPumpTask_3' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. ( (80004005): )
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
Any idea will be welcome.
Thanks
LucasC |