eschan

Has anybody successfully got SSIS to talk to a WCF Host WebService (wsHTTPBinding)




Re: Windows Communication Foundation (Indigo) WCF and SSIS - Web Service Task

Yavor Georgiev - MSFT

Hi eschan,

Thank you for your question. Does this thread help

http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=1023821

Thanks,

-Yavor





Re: Windows Communication Foundation (Indigo) WCF and SSIS - Web Service Task

eschan

I saw that, but doent help...

From SSIS, I can download the WSDL, and when I select "Input" and Service, i get this error

"Cannot find definition for Microsoft.ServiceModel.Samples:ICalculator. Service Description with namespace Microsoft.ServiceModel.Samples is missing. Parameter name: name:

Any ideas

Code Snippet

using System;

using System.ServiceModel;

namespace Microsoft.ServiceModel.Samples

{

// Define a service contract.

[ServiceContract(Namespace="Microsoft.ServiceModel.Samples")]

public interface ICalculator

{

[OperationContract]

double Add(double n1, double n2);

}

// Service class which implements the service contract.

public class CalculatorService : ICalculator

{

public double Add(double n1, double n2)

{

return n1 + n2;

}

}

}

Code Snippet

<

< xml version="1.0" encoding="utf-8" >

<configuration>

<system.serviceModel>

<services>

<service

name="Microsoft.ServiceModel.Samples.CalculatorService"

behaviorConfiguration="CalculatorServiceBehavior">

<!-- this endpoint is exposed at the base address provided by host: http://localhost/servicemodelsamples/service.svc -->

<endpoint binding="wsHttpBinding" contract="Microsoft.ServiceModel.Samples.ICalculator" />

<!-- the mex endpoint is exposed at http://localhost/servicemodelsamples/service.svc/mex -->

<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />

</service>

</services>

<behaviors>

<serviceBehaviors>

<behavior name="CalculatorServiceBehavior">

<serviceMetadata httpGetEnabled="True"/>

<serviceDebug includeExceptionDetailInFaults="False" />

</behavior>

</serviceBehaviors>

</behaviors>

</system.serviceModel>

</configuration>






Re: Windows Communication Foundation (Indigo) WCF and SSIS - Web Service Task

Paul Shippy

Same problem here.





Re: Windows Communication Foundation (Indigo) WCF and SSIS - Web Service Task

Paul Shippy

Fixed!

I had the same error when using SSIS to call a WCF Web Service

Cannot find definition for ....
Service Description with namespace ... is missing.
Parameter name: name

After half a day of troubleshooting, I found a solution. It was being caused by the fact that my contract class had a namespace specified in a parameter of the ServiceContract attribute:

[ServiceContract(Namespace = "MyNamespace.Was.Here")]

public interface MyContract

I changed it to:

[ServiceContract]

public interface MyContract

Once I removed the namespace parameter, the generated WSDL changed significantly and the error went away. Of course, I had the same issue that is described here: http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=1023821. So, I deleted the right <xsd:import> node after downloading WSDL as recommended, and then my SSIS Web Service Task could successfully call my WCF Service.

Paul Shippy





Re: Windows Communication Foundation (Indigo) WCF and SSIS - Web Service Task

Paul Shippy

Here's another post with more on this:

http://www.ayende.com/Blog/archive/2007/05/06/WCF-and-SSIS-Round-2.aspx

It looks like you can specify a namespace, as long as you make sure the namespace of the ServiceContract matches the namespace of the service itself.

Paul Shippy