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.

--Drew

[quoted text, click to view]

Salim,

You can call the dtsrun utility using master..xp_cmdshell or write sp_oa*
calls to do the same.Details here
http://www.sqldts.com/default.aspx?6,104,210,0,1
Another option would be to include the dts package inside a sql job and then
call the job using sp_start_job inside the stored proc, the downside is that
you cannot have two instances of the same job running at the same time.

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com

[quoted text, click to view]

Hi,
How can I run a DTS Package with T-Sql?
I need to run it with a Stored Procedure.
Thanks,
Salim

dtsrun is a command line utitlity which runs the DTS package. you can call
this utitlity using xp_cmdshell inside a stored procedure. you can get more
help on DTSRUN in BOL.

-Vishal

[quoted text, click to view]