How do you do the latter as i thought they all had to same dimenensionality?

with a condom!

So what is the solution?

Thanks for your reply.

Its not the package isnt an issue as i can run the sp from ssms to add the request to the service broker queue.

Its from there thats...

Just a quick stupid one!

Ive set this up in its own MyAppServiceBrokerDB and it works fine for local stored procs.

How do i execute sp's in a different database? (both dbs...