« Brandon gets global cred! | Main | BizTalk User Group - London »

September 10, 2006

BizTalk 2006 and CLR Stored Procedures

On my current project, we are making use of SQL 2005's ability to write stored procedures in C#. I went to configure a SQL send adapter to call one of the CLR sprocs, and was suprised to find I could not call it! It turns out, BizTalk is not able to call CLR procedures, unfortunately.

As a work-around, we created a wrapper procedure in good-old T-SQL, which in turn calls the CLR sproc. Not the most elegant solution, but it worked in our scenario.

Posted by ben at September 10, 2006 09:00 AM