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!!!
View Complete Post