DTS Designer ActiveX Call "function" Type Mismatch - 03-23-2005 , 03:56 PM
I am going a GUI DTS Job that reads in values from an INI file supplying
True/False values to a list of activities. An ActiveX Task1 checks
parm1=true/false, if false it goes to ActiveX Task2 and checks
parm2=true/false. If ActiveX Task1 parm1=true then several tasks would be
executed and then control needs to go to ActiveX Task2 to check parm2. So
basically, alkl ActiveX tasks need to be invoked serially, and If any edits
were true then work needs to be completed prior to invoking next ActiveX
So every ActiveX Task has the ON FAIL flow control going to it. And it
doesn't work having any ON SUCCESS or ON COMPLETION going to the same task
the ON FALSE goes to as both sets of conditions cannot both be met.
I did put a stubb AxtiveX Task after each series of work tasks that gets
fired when all those tasks complete, and it just has code that issues a Call
DoParm2Check() in it to force control now going to that task to continue. I
had it working in a highly limited test DTS job to test proof of concept.
However, putting the code into the real DTS job now causes calls to the
subsequent ActiveX Task to fail with a "Type MisMatch".
Is there a way to coerse this to work as intended...?