Executing a DTS Package using T-SQL

[Middlej]

Does anyone out there have any tips or ideas as to how one can execute a DTS package using Transact-SQL code? The idea is to have certain external data sets imported only if certain conditions are met. Such an example MIGHT look like (note: I've tried this, it doesn't work):

USE [Database Name]
GO

IF dbo.tablename.colname = 1
BEGIN
EXEC [packagename]
END
GO

Anyone?

Thank you

 

[tlbroadbent]

Check the following link on the SQLDTS website.

Execute a package from T-SQL

http://www.sqldts.com/main.asp?nav=1,6,210,0

The IF statement will not work as coded. It should look something like the following.

IF Exists (Select * From dbo.tablename Where colname = 1) Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.