Is it possible to call a DTS package in a stored procedure

Hi,

I wanted to know if i can a DTS package using a stored procedure and if yes how should i do it.

Regards,

Karen

You should be able to use XP_cmdshell or DTS run for this, Look at this link

http://www.databasejournal.com/features/mssql/article.php/1459181

Thanks

Raj