Use ActiveX script for DTS package workflow

Hello,

Does anyone know how to setup an ActiveX script to test some conditions and then based on those. Run the necessary SQL Task?
So for example. I have the ActiveX script that looks at a global var. If it's 1 then do SQLTask1 Else do SQLTask2

Thanks.