Is the SP executed through a SQL task? Do you know what SP is trying to be executed? I've never looked into this but does DTS uses SP's within the...

Your problem is that the sub query (Select statement) is returning more than one value for 1 or more DIAGNOSTICPROCIDs and SQL server is cannot decide which one to use.

You...