Could Not Execute The Web Method. The Error Is Method
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SSIS Web Service Task Error with WCF Service SQL Server > SQL Server Integration Services Question 0 Sign in to vote I have read all the other posts on this site and have not been able to resolve my issue.For testing purposes i created a very simple WCF service that takes no arguments and returns true. That is all it does.When i create a winform client and instantiate the service i can run my service method and get true back so i know the service works.I then create a test SSIS package with 1 task, a web service task. I set the web service tasks properties as follows:http connection: http://localhost/WCF_SSIS_Prototype/Service1.svcwsdl file: C:\...\SSIS_WCF_Prototype\Service1.wsdl (I know this is not a valid path, i changed it for posting to forum)Service: Service1Method: GetDataVariable: User::BResultWhen i run the package i get the following error:[Web Service Task] Error: 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.Service1.GetData' not found.. 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'm not sure why it is saying "Method 'ProxyNamespace.Service1.GetData' not found. It the web service task trying to create a proxy class and naming the proxy class namespace ProxyNamespace? Any help is greatly appreciated. Monday, December 08, 2008 10:43 PM Reply | Quote Answers 2 Sign in to vote First,
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1073ad37-ed05-4ab4-85e3-689e1cd17a68/ssis-web-service-task-error-with-wcf-service?forum=sqlintegrationservices other. Join them; it only takes a minute: Sign up SSIS web service task, can't execute web service up vote 1 down vote favorite Hi I have a web service that is called from my ssis. Used to work fine in test mode, when moved to live environment I get the error : [Web Service Task] Error: An http://stackoverflow.com/questions/868350/ssis-web-service-task-cant-execute-web-service error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. 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()". We are using a proxy to access the web. Could this be a proxy problem. how to solve ? Thanks ssis share|improve this question asked May 15 '09 at 12:16 freddoo 3,79922132 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote To help diagnose this, you might try using a script task and adding a Service Reference or Web Reference to the web service. Call the service within a try/catch block and log ex.ToString() if you get an exception. That way, you'll be sure to have all the details, and you can post them here in an edit to your question. share|improve this answer answered May 15 '09 at 12:19 John Saunders 138k20175319 add a comment| up vote 2 down vote ac
Method 'ProxyNamespace.ServiceNow_GetMetric.query' not found.. Posted By: Posted http://www.dotnetspark.com/links/43038-error-is-method-proxynamespaceservicenow_getmetricquery.aspx Date:October 18, 2010 Points:0 Category :Sql Server Hi guys http://www.bigresource.com/MS_SQL-Using-ssis-task-to-call-a-web-service-G4fbB1lV.html - I am working on a project where I need to call a WebService Method via the WebService Task in SSIS, and I am getting below error . The content of the WDSL file is also attached. Has anyone could not got this kind of error? I use BIDS with SQL Service 2008/Windows XP professional. Thanks for your help Lazalo "[Web Service Task] Error: 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.ServiceNow_GetMetric.query' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo could not execute 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()". WDSL File content: with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. 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()". This is probably because i never worked with this task, even so, does anyone knows what might be wrong? I got a connection a wsdl, i can configure the service, method and variables(i use fixed values), and i configure the output to a variable with the type object(i have tryed string and int) I even can download the wsdl file, but the error seems to be in the connection Thanks View 7 Replies Similar Messages: Amazon Web Service Call With Web Service Task Call Web Service From Script Task Call SSIS Remotely To Run Exe Task In Server By C# Integration Services :: Call Stored Procedure Result In Message Box In SSIS Script Task SSIS Web Service Task SSIS Hard Time Getting Back XML Return Data From Stored Procedure Call Executed By Execute SQL Task SSIS Web Service Task Input Parameters SSIS Calling Web Service Task 401 Unauthorized Error SSIS Web Service Task - SOAP Header Input Adding A Web Reference (web Service) To An SSIS Script Task? SSIS SQL 2005 Script Task For Windows Monitoring Service Problems With Connections And Analysis Service Processing Task In SSIS How Do I Call A Stored Procedure To Insert Data In SQL Server In SSIS Data Flow Task What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration? Can I Call A Web Service From SQL?? Why Cant I Call A Sql Web Service From A Url? Call .NET Web Service From SQL Server Call Web Service From The Database Call A WCF Service From SQL CLR Sproc The Task FTP Call Cannot Run ... Call Web Service From Sql Server 2000 Job MS Reporting Service - Call Code Web Service To Call Integration Services Trying To Call The Function A Web Service From Transact-SQL How To Call Web Service From Within Script Component ? Web Service Call Parameter Greater Than 4k Char How To Use A Dialog Retry Timer For Doing A Web Service Call Dts : Call 2 Procs Within One 'execute Sql Task' JDBC SQL Call Failure After Database Service Is Restarted Deploying CLR Sps Or Functions Which Call A