I don't think the stored proc is at fault. Typically if the select statement or stored procedure is at fault you will get an error message.
Have you checked MSDTC connectivity to this SQL Server.
A quick check is to run the wizard and use a select statement you know will work
like: select * from sysobjects for xml auto