• 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 your step 1. It would be an Execute SQL task.