I figured this out a LOOONNG time ago, but couldn’t find it quickly when I needed it today. Like many things I post, I do it for myself so that I can easily find it later.
So, if you want to call a DTS Package from a sproc, here’s the code:
//Replace DTS_NAME with the real package name exec master..xp_cmdshell 'dtsrun /s localhost /e /n DTS_NAME'