Linked Server Issue in SSIS -Multiple-step OLE DB operation generated errors

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  October 5, 2010 at 4:35 pm

  #387944

  Hi All,

  When I ran a stored procedure in SQL server Management Studio which inserts/updates values into a table in a linked server the SP executes correctly, but when I run the same in SSIS, i get the following message.

  OLE DB provider "SQLNCLI" for linked server returned message "Multiple-step OLE DB operation generated errors.

  I ran the SP and the SSIS using Windows Authentication. The tables that I am inserting/updating values has a primary key.

  Anybody's thought on what is going wrong with SSIS?

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  October 5, 2010 at 6:45 pm

  #1232179

  The issue with the linked server was the windows authentication. When I changed the linked server's properties to use:

  Be made using the security context using Remote Logn and password instead of Be made using login's current security context it worked.

  When I execute the SP as an execute SP task it works fine where as when i have the same in sequence container it fails.