December 15, 2010 at 9:56 am
I've been struggling with this for a day and going on half now. Any help is greatly appreciated.
I have a WCF service hosted by my local site. Binginds are configured for basicHTTP with no authentication. Service has been tested with WCFTestClient and it works fine. I am not specifying a namespace for the service contract.
Enter SSIS. Created the HTTP Connection and added the WebService Task. Downloaded the WSDL. COnfigured everything to the best of my knowledge and when I execute I get the following Exception:
[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.Transactions.ImportTransactions' 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, VariableDispenser taskVariableDispenser)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
So I read somewhere that the there was a problem with the importing of the schemas for the WSDL and so I removed the Tempuri.org line. Got a new error. At this point I went back the WCF service contract and added a namespace. Rebuild the solution and tested again with WCFTestClient.exe and it worked as expected. Went back to the SSIS project and downloaded the WSDL again. Verified that the Tempuri.org reference was gone from the WSDL. Now I'm getting the following error when executing the Task:
[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: System.ArgumentException: Cannot find definition for KHE.PaymentCenter.Web.Services:ITransactions. Service Description with namespace KHE.PaymentCenter.Web.Services is missing.
Parameter name: name
at System.Web.Services.Description.ServiceDescriptionCollection.GetServiceDescription(XmlQualifiedName name)
at System.Web.Services.Description.ServiceDescriptionCollection.GetPortType(XmlQualifiedName name)
at System.Web.Services.Description.ProtocolImporter.GenerateCode(CodeNamespace codeNamespace, ImportContext importContext, Hashtable exportContext)
at System.Web.Services.Description.ServiceDescriptionImporter.Import(CodeNamespace codeNamespace, ImportContext importContext, Hashtable exportContext, StringCollection warnings)
at System.Web.Services.Description.ServiceDescriptionImporter.Import(CodeNamespace codeNamespace, CodeCompileUnit codeCompileUnit)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvoker.generateProxy(ServiceDescriptionCollection sdCollection, XmlSchemas schemas)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
December 16, 2010 at 1:09 pm
I can't believe I'm the only one who's run into this...?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply