How to get output from trigger on linked server
Have you thought about modifying your trigger to put that integer into a table?  Include some identifying information, say the primary key from the table you are inserting into.  Then just query the table after the insert.