Re: SQL Adapter calling stored procedure that returns a number via a SELECT statement

Hey, is there a FOR XML AUTO, <ELEMENTS> at the end of the SELECT statement?  Otherwise, BizTalk can't read it.  For what you're doing, assuming you aren't passing too much into the proc, I'd just write a .NET component that calls the proc and returns the "int" back to the orchestration.  For me personally, unless I'm returning a block of data from a stored proc, I prefer helper components that I can call from the orchestration.