Thanks for your response Kim. SQL Server is what we are using.
We have worked our way around the problem with a lot of trial and error by creating a mostly empty Stored Procedure with the correct parameters, importing that into Mapping Tool, then changing the stored procedure to what it should be.
There were a number of issues which i think boil down to the Mapping Tool looking at the creation of a Temporary table in the SP and finding (of course) that it doesnt have a schema specified. That line produced the error.
The old ones that 'worked' did so simply because they did not have any lines that caused the new ones to fail.
This really doesnt make much sense since Ideablade doesnt need to know anything about what is inside the procedure, just the params and what is returned.
Anyhow, we are moving again so that is good.
Thanks
Andrew