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.
quote:Originally posted by Reddy
How can I run a DTS pkg from a SP? Does any one has code for that?
Thanks!
"He laughs best who laughs last"
declare @cmd nvarchar(1000)
set @cmd="He laughs best who laughs last"
‘dtsrun /S’[email protected]@servername+’ /Ndtspackagename /EMicrosoft OLE DB Provider for SQL Server’
exec master..xp[underscore]cmdshell @cmd, no_output
]]>