dbTalk Databases Forums  

DTS Designer ActiveX Call "function" Type Mismatch

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Designer ActiveX Call "function" Type Mismatch in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
doug
 
Posts: n/a

Default 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
task.

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...?

regards,

doug



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.