Not compatible witih version of Oracle client in Web Service Task within SSIS

• J.O.

  Right there with Babe

  Points: 756

  More actions

  April 21, 2014 at 4:42 pm

  #285896

  I have a web service that was given to me and this web service calls a procedure in Oracle that requires input parameters. I create a web service task in SSIS and i can see the methods just fine and all the parameters for the web service. However when I fire the task I get this error:

  [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Server was unable to process request. ---> The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. ---> The provider is not compatible with the version of Oracle client.

  at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)

  at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)

  at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

  I haven't been able to find anything in regards to SSIS and this error. Everyone that gets this error from what I have seen they are developing an app, and usually the solution with this is to copy over some oracle dll's from ODAC and make a reference to one of the dll's in the code and it works. But since this is within SSIS i am stumped. I thought the connection was being made to Oracle within the web service, or am I just missing something. Anyone else doing something similar to this and can point me in the right direction?

  Any help is appreciated.

  Thanks!