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

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.

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 http://www.webservicex.net/GenericUNSPSC.asmx, 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

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

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