Problem Calling a SQL Server Integration Services (SSIS) package from s stored procedure should be an easy task however Microsoft has provided no direct method to do so.

A quick search on Google found this CodePlex example which uses the xp_cmdshell extended...
Shout it
Only $4.95/month – Windows 2008/ASP.NET 4 Hosting!
.