You can setup a job to execute the package and start the job by using System procedure.

or

you can create a bactch file and trigger the batch file in your SP

or

you can use OLE Automation procedure to call an SSIS package.

or

The above way...using XP_cmdshell

to use xp_cmdshell/OLE Automation procedure, you must enable the property on your SQL Server.