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

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Adapter calling stored procedure that returns a number via a SELECT statement › Re: SQL Adapter calling stored procedure that returns a number via a SELECT statement

November 30, 2006 at 8:59 AM #16638
community-content

    Hi

    no there is no xml auto … it does work though if the reponse is char rather than int – I would have expected that not to work either.

    I am working with several hundred legacy stored procs on an MSSQL 2000 db, so I can't go changing them. It'd be a shame to have to bypass all of the standard BTS functionality … in fact it would be a major problem since we are supposed to be adopting BTS as our corporate standard workflow / interfacing tool !

    Thx for the reply

    Bob