dbTalk Databases Forums  

Transactions against AS 400

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Transactions against AS 400 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
LucasC
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.