Exec DTS step using other DTS step BUT NOT workflow

#1

Hi All,
I have to steps in DTS which I want to run in indeterminate loop.
DTSStep_DTSActiveScriptTask_1
DTSStep_DTSActiveScriptTask_2

In DTSStep_DTSActiveScriptTask_2, Though VB Script in Main() I am trying to
execute DTSStep_DTSActiveScriptTask_1
Set oPkg = DTSGlobalVariables.Parent
Set oStep = oPkg.Steps("DTSStep_DTSActiveScriptTask_1")
oPkg.Steps("DTSStep_DTSActiveScriptTask_1").Execut ionStatus =
DTSStepExecStat_ExecuteTask

but its throwing error "Invalid step status"
How to execute DTSStep_DTSActiveScriptTask_1 on completion of
DTSStep_DTSActiveScriptTask_2. I don;t want to use workflow.

Regards

Abhijeet

#2

The Step execute method is really only their for the Designer. It is not
recommended that you use this at run-time. Use workflow.

Your error is caused because the ExecutionStatus property is read-only.

--
Darren Green
http://www.sqldts.com

"Abhijeet Raje" <abhijeet2804 (AT) hotmail (DOT) com> wrote

Quote:

Hi All,
I have to steps in DTS which I want to run in indeterminate loop.
DTSStep_DTSActiveScriptTask_1
DTSStep_DTSActiveScriptTask_2

In DTSStep_DTSActiveScriptTask_2, Though VB Script in Main() I am trying
to
execute DTSStep_DTSActiveScriptTask_1
Set oPkg = DTSGlobalVariables.Parent
Set oStep = oPkg.Steps("DTSStep_DTSActiveScriptTask_1")
oPkg.Steps("DTSStep_DTSActiveScriptTask_1").Execut ionStatus =
DTSStepExecStat_ExecuteTask

but its throwing error "Invalid step status"
How to execute DTSStep_DTSActiveScriptTask_1 on completion of
DTSStep_DTSActiveScriptTask_2. I don;t want to use workflow.

Regards

Abhijeet

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Exec DTS step using other DTS step BUT NOT workflow

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

Exec DTS step using other DTS step BUT NOT workflow - 10-06-2003 , 03:40 AM

Re: Exec DTS step using other DTS step BUT NOT workflow - 10-06-2003 , 06:27 AM