John
One way to store your SSIS packages are to utilize the Integration Services Catalog. When in there, you can execute those using SQL jobs and such, but you can also execute them using just SQL:
If you want to check the status and the output:
You can then do some logic with the output information.
