How do you call a package from a stored procedure?

I call from ASP.NET code behind, but you should be able to do the same using this format....

Create a SQL Server Agent Job

Create procedure to execute:

EXEC MSDB.DBO.SP_START_JOB N'SQLJobName' 

Select allOpen in new window

I'm using sql server 2008 r2.  I'm calling the package from a share and passing three variables to the package.

error is dtexec is not recognized as an internal or external command

you need to provide the exact path. do a search on windows on the server and find the path

Aneesh, your first solution assisted me.