I have several WCF web services that I call using SSIS 2008. Using the web services standard HTTP connection manager (http://mywebservice/myfunservice.svc?wsdl) it works just fine. However, there are web services that use netTCP bindings. I have tried in vane to get netTCP to work by doing funny things like net.tcp://mywebservice/myfunservice.svc and nettcp://mywebservice/myfunservice.svc but nothing seems to work. I get an error saying the prefix is not recognized. I prefer not to use a C# script task.
How do I create a connection in Connection Manager and use the Web Services Task in SSIS 2008 while using netTCP?