How do I execute a SSIS pkg from within a SQLServer stored procedure

[DickB1]

We have a generic stored procedure to execute DTS packages. Does someone have code to do the same for a SSIS package stored in the MSDB database?

 

[RiverGuy]

I would never do this, nor would I ever want to. Try to keep as much non-TSQL stuff out of stored procedures as you can.

But, if you must, I suppose you could use xp_cmdshell in conjunction with the DTExec.exe executable on the server.