execute a DTS package via some SQL

[TomBarrand]

Is it possible to execute a DTS package via some SQL?

Cheers

 

[KenKimbrough]

I create a stored procedure that runs a DTS Package and pass a parameter into the stored proc to be used as a parameter in the DTS package.

CREATE PROCEDURE sp_exec_DTS
@ID int
AS
Declare @DTS_string varchar(200)
Select @DTS_string = 'DTSRun /S /E /N "DTS Package Name" /A "ID":"3"="' + Convert(char, @ID) + '"'
exec master.dbo.xp_cmdshell @DTS_string