Consuming Web Services from SSIS package
Hi, I'm trying to consume web service using SSIS package. However, I'm receiving an error saying that the Web Method is not found. I followed all instructions from MS site and did an extensive research on this issue. Did anyone ever had this problem? Im using Business Intelligence 2005. Thank you
September 29th, 2011 9:33pm

Hi AppDev123, I'm going to help move your post to the SQL Server Integration Services Forum for more efficient response. Thanks for your understanding. Best Regards,Andrew Wu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2011 5:32am

Hi AppDev123, Have you tried to test the web services via browser to see if you can list down its supported operations? For example: if you go to, you can see list of supported operations for United Nations Standard Products and Service Code. And what is the full error message that you receive? Cheers, Uzie
October 3rd, 2011 5:41am

Hi. Thank you very much for the reply. Here is the full error message: Web Service Task: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.UserListService.getUserList' not found.. Thank you.MS
Free Windows Admin Tool Kit Click here and download it now
October 3rd, 2011 8:28am

Hi AppDev123, Are you using the same account (your Windows login or SSIS service account) when you run the package? And have you try to just browse to the Web Service like I mentioned in my previous post just to see if you can access it? From the error message, it looks like either you don't have permission to see call the method or no access to Web Services itself. Cheers, Uzzie
November 19th, 2011 6:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics