We are just not sure how to automate running the proc for each group for each process code...
There's more than one way that this might be done, but one which should definitely work is this:
1) Create a physical 'work' table which will hold the results that the proc outputs.
2) Modify your existing proc to append its results to this table.
3) Create a 'master' proc which does the following:
a) Truncate the work table.
b) Loop round all group-process combinations and call the child proc for each.
Your SSIS package now takes the work table as its input ...
Perhaps even better would be to modify your proc to do all of the work in one shot, but maybe that's too complex to code/handle - I'm in no position to assess that. But I did study to be an actuary years ago and know that nothing is simple in that field.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.