I set up one DTS job to run for two different groups. There are some tables
which should not be loaded for one of the groups. For the stored
procedures, I pass a parameter and then based on the parameter the stored
procedure executes the required code. For the data transform tasks, is there
a way to test a variable and then execute or not execute a specific data
transform task based on the value of that variable ?

Hello rmcompute,

Sure

You are looking at conditional workflow. In your case you would probably
use an Active Script Task and see if the variable is populated. if it is
then you can enable one path in your package and disable the other + vice
versa


Allan

Thank you Allan.

"Allan Mitchell" wrote: