DTS workflow branching based on query results
Posted on 2006-10-27
I have DTS package that runs an Execute Process Task. Prior to running the task I want to check results from a couple of queries that I have. Basically the queries are stored views that check for missing members in certain tables. The queries should always come back with a null result, in which case the Process Task should run, if however one of the views does return a record (1 or 1000 records, doesn't make a difference) then the Process Task should not run.
I'm figuring I need a VBscript or maybe a stored procedure, but I'm not very good with either so please give me some good ideas and provide a lot of details on how to implement.
Tanks in advance.