One method is by using DTSrun utility and the xp_cmdshell stored procedure.
You can look at the specifics of the DTSrun utility in the BOL.
"Salim Afþar" <safsarluckyeye.com> wrote in message
> How can I run a DTS Package with T-Sql?
> I need to run it with a Stored Procedure.