Why does it matter that you have two steps?

One possible solution would be to modify your SSIS package to include the execution of the stored procedure eliminating the need for...

Break down the query and start answering what is and is not working.

select a, b, c

from openquery (REM_SERV,'select a,b,c from X, Y, Z') ;

Does this Execute?

select a, b,...