Click here to Skip to main content
15,903,175 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hello everybody!!
i need to connect to a wcf service from a job in the sql server, i have been looking for diffrent ways to do so and in the mintime
i found only 2 ways.

1. creating an ssis web service and configuring the wcf service protocole to work with basichttp instead of wshttp
and configuring it to create a WSDL file to submit to the http connection manager in the ssis package, the problem with this method is
that i have to keep a copy of the WSDl file on the local machine and that could be a problem in the long run.

2. using and enabling SQLCLR in the sql server 2008 r2 i can access the wcf service by adding some dll's from the .net framework,
but the framework has to be 3x and below. sql server 2008 r2 does not support framework 4x becouse 4x runs 2 diffrent instances
and 3x runs one instance the 3x CLR uses some lockinstance method and it dosent comply with the 4x framework.
i am developing on 4x framework with visual studion 2010 so it dosent work with sql 2008.

i need your help!!!
i searched for other methods but ididnt find any other then this 2
please assist me!!!
Patrick Kalkman 13-May-11 16:43pm    
Is it an existing service? If you are able to reconfigure the service you could try to convert it to a rest service. Then calling the service would be as simple as calling an url.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900