Q:

How to automatically execute stored procedures in a particular sequence, or use an SSIS package to execute stored procedures?

I have created 2 stored procedures that need to be executed in a specific sequence. 
I just do not know how to do this. I also want to do it automatically everyday with GETDATE() as the parameters to both procedures. 
Is there an SSIS package I can create to execute these two procedures in the proper sequence for me?

A:

You want to create a job, make each procedure call a step within the job and then run the job on a defined schedule.

