Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: KenKimbrough
- Order by date
-
execute a DTS package via some SQL
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"="' +...- KenKimbrough
- Post #2
- Forum: Microsoft SQL Server: Data Transformation Services
