Using SQL Server 2005 Schemas With BizTalk 2006 SQL Send Adapter

I'm using SQL 2005 and have used the new database schemas facility to group my tables and stored procedures into different functions. For example, I have a schema called Customers and within this I have a stored procedure called InsertNewCustomer. To execute it using T-SQL I would use "EXECUTE Customers.InsertNewCustomer".

I have created a SQLService schema using the Generated Items wizard which has let me select the stored procedure in the wizard and has extracted the correct parameters. However the script it generates just says "EXEC [InsertNewCustomers] ……" instead of "EXEC [Customers.InsertNewCustomer] …….". When I use this schema in my SQL Send Port I get an error in the log saying that the object InsertNewCustomer can't be found.

I've tried editing the schema within VS2005 but was unable to change the query part of the schema (msbtssql:sqlScript value=). I've then tried editing the schema using the XML Schema editor which let me change the EXEC statement to include the SQL Server schema name before the stored procedure name. I built and deployed this, stopped and restarted my app and host instance and then tested it again but it stil says that the object InsertNewCustomer can't be found.

At the moment I can get round the issue by putting my stored procedure back into the dbo schema. However, it seems that BizTalk 2006 is not aware of SQL Server 2005 schemas. Is this a bug in BizTalk 2006 (or an incompatibility) or am I doing something wrong here?