Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Transfer from SQL Server to AS400 Expand / Collapse
Author
Message
Posted Friday, October 15, 2010 2:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 9, 2012 4:17 AM
Points: 12, Visits: 113
Hello,
We have a requirement to transfer data from SQL tables (may be derived data) to AS400. With this SQL server also need to get intimation from AS400 as it has processed all records and updated in their system. If any issue is there AS400 need to be sent it back for that particular errornous row.
This interface will be running in real time as a scheduled job hence SQL server need this information so that when next time job will run it should not send data which is already being sent earlier and proceesed successfully by AS400. Basically we need flagging.

Has anyone done a similar kind of approach earlier?
Can we update AS400 data (I am not sure of AS400 structure) from SQL?

Please assist

Tahnk You
Post #1005570
Posted Wednesday, August 6, 2014 12:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 5:09 AM
Points: 9, Visits: 21
hi
i am also facing same problem . if you know something about this.please let me know how to solve this problem. i am some error like this:


[OLE DB Destination [26]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Could not create an acceptable cursor.".
Post #1600066
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse