Elliott,

Thanks for the reply!

The caller sproc recieves the name of the linked server and some parameters to pass to the sink as a parameter and then the only...

Florian,

Thanks for the reply and code sample! This is exactly the help i needed. Hope I can do the same for someone in the future.

Thanks for the reply. I believe you. However, my version of BOL does not state that anywhere in the CREATE PROCEDURE topics. Regardless, it doesn't work.

Thank you both for your replys...the qualifying of the table name on the ID = filter was the missing piece for me.  Thanks again.

Steve