I am trying to write a DTS which runs one of two different DTS scripts
depending on the data in one table in the database.

I think I am looking for an "if" or "case" type statement... is there such a
thing? Do I have to break down and write VB?

This is on Windows 2000 with SQL 2000.

Thanks a bunch!

Ben

Hello Ben,

Basing on a query on your driving table you could properly set a Global Variable;then
you could use an Activex script where, testing the value of this Global Var,
you decide what to do in your ActiveX script. to perform this,unfortunately,
you should break down to VB....well... VB Script.
Bye Ben

Davide

Hello Ben,


My package for this would probably look like


ExecuteSQL task read the value from a table into a variable
On Success
Script task to test the value of the variable.
From the script task we have two On Success constraints. Depending on the
value in the variable we enable/disable the attached step.


We do this here

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

In step 4


Allan