how to load data from sql server to AS400 through linked server

• bayapareddy.msbi

  SSC Enthusiast

  Points: 153

  More actions

  August 6, 2014 at 12:59 am

  #147047

  hi,

  i am able to load data from as400 to sql. but when i am loading data from sql server to AS400 i am getting error.

  error;

  [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.".

  please any body can help how to solve this problem

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  August 6, 2014 at 1:07 am

  #1735505

  Google on this error message and try some of the suggestions that you find:

  Could not create an acceptable cursor.

  I've seen some resolutions where the error was caused because there was no unique index or primary key on the destination table.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP