SQL Adapter

Hi all

I have a BTS04 solution and I am wanting to add a schema that calls an SP.
Now I have done this many many times in the past without an issue, but on this particular occasion whenever I try and add the schema it only returns “success” as an xml key instead of the fields that are supposed to come out of the SP.
I have ensured that I have my select line as follows …
“SELECT value1, value2, value3 FROM myTable FOR XML AUTO, XMLDATA”

When I run the SP from Query Analyzer I get the correct format but when I add it from within Biztalk it does not return the XML tags – only ‘SUCCESS’

Any ideas?

PS: I have tried to change AUTO to RAW but then the SP doesn’t compile