@@ROWCOUNT or an output clause will return the inserted record count in your SQL procedure. Assigning this value to an output parameter or just doing a SELECT as the last action in the procedure to return it will bring back the value from the procedure.

A quick Google on returning a value from execute SQL tasks will probably explain better and more comprehensively how to setup SSIS to consume the value returned from the stored procedure. For example: https://www.simple-talk.com/sql/ssis/ssis-basics-using-the-execute-sql-task-to-generate-result-sets/

If you're looping multiple times and need to record multiple row counts I'd use a For Each loop component and a second variable to record the overall count. Expression Task or Script Task to update the overall count with its current value + the returned count

Hope this helps get you a bit closer