How to run a ssis package using a sql statement?

i'm using Sql Server 2008. There are options to run from command line. Is there a wa开发者_如何学编程y to execute an ssis package using sql statement?

-Vivek

---

Im my experience one of the easiest way to control them from within SQL is not to try an xp_cmdshell etc but to add a job that executes the SSIS package as the first step and then from within the SQL msdb.dbo.sp_start_job 'yourjobname'

This also makes it easy to control which account (via proxy / credential) the job gets run under.