December 29, 2008 at 8:28 am
Hi,
I am new to SSIS. I am developing an SSIS Package to read data from an API. The API returns data in XML format. I am using WebService task to connect to the API. I have defined HTTP Connection and gave path to WSDL File and also mentioned Service name in Input Page of WebService Task. I am able to run the Package successfully for one Method ( It created an output file successfully), but for another method (in same API) the package is failed with the following 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. ---> Invalid Login. 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) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
I do'nt understand why one method is working and another is failing. Please help me to solve this issue. Am I missing anything ? Is there another way to connect to a WebService(API) ?
I tried it by using Script Task, but I am poor in VB coding.
Please help me.
Thanks,
Shiri.
December 29, 2008 at 8:40 am
It seems like the login that you are using to access the API, does not have permissions for the method that you are trying to call.
Are you able to check the permssions that you have?
December 29, 2008 at 9:46 am
Thanks for quick reply.
I have the API installed on my PC and I am able to run that Method in API with the same username and Password. Is there a chance of authentication issues for that specific method?
Thanks,
Shiri.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply