call a stored procedure for data push

Is it possible to call a stored procedure on the remote sql server to do a push (insert the data onto the main sql server)?

Yes, you can use SubmitSQL with any valid SQL server commands, that do not return rows.