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….