Calling tasks like this is a no-no. What you do is you have workflow so
The Active Script task would set the step that it wants to execute to
enabled and the others to disabled.
Have a look at the site
Workflow
(http://www.sqldts.com/Default.aspx?103)
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Andy C" <Andy C (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi,
I have an ActiveX task that I need to call one of four other tasks
depending upon a variable that I test in a Select Case statement. Two are
|
ExecuteSQL tasks and two are DataDrivenQuery tasks.
Quote:
What is the syntax for calling tasks that exist in the same package from
within an ActiveX script? As I'm testing more than yes/no, I can't use
|
workflow on success/failure.
Quote:
Thanks
Andy C
Thanks very much.
|
Re: ActiveX Task calling other DTS Tasks -
08-04-2004
, 02:26 PM
Linear Mode
