Created On: 7/14/2005 2:11:00 PM Create the following procedure and place it in your master table:
CREATE procedure sp_DTSRun @DTSName varchar(50)
as
Declare @command varchar(200)
set @command='DTSRun /S NAME_OF_YOUR_SERVER /N ' + @DTSName + ' /E'
EXEC master.dbo.xp_cmdshell @command--,NO_OUTPUT
GO
In ASP use the following code to execute your DTS Package:
sSQL = "Master.dbo.sp_DTSRun '" & PackageName & "'"
Set rsMsg = cn.Execute( sSQL )
Note: Use can use the recordset to trap any error message. |
