SQL Server Performance Forum – Threads Archive

from SP

How can I run a DTS pkg from a SP? Does any one has code for that? Thanks!
"He laughs best who laughs last"

---

Have you ever heard of DTSRUN utility, BOL is your BF. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

declare @cmd nvarchar(1000) set @cmd=
‘dtsrun /S’[email protected]@servername+’ /Ndtspackagename /EMicrosoft OLE DB Provider for SQL Server’
exec master..xp[underscore]cmdshell @cmd, no_output

---

]]>