Precedence constraint does not run in SSIS package
When you run the stored procedure from the Execute SQL Task add the OUTPUT keyword to the parameter that will be returned.  For instance 

EXEC dbo.OpenExcel ?, ?, ? OUTPUT