DTS Package Execute - Checking status of steps

#1

If a package has several steps and some of these do not run by design
(e.g. they only run if a specific step fails) then looping through the
steps checking for status as suggested in other posts does not always
help:

opkg.execute
Steps_Success = True
for each ostep in opkg.step
if ostep.Executionresult = DTSStepExecResult_Failure then
Steps_Success = False
end if
next
if Steps_Success = False then... ' take some appropriate action

The Executionresult property only returns Success or Failure. Any step
that "was not executed" returns Failure. Are there any work-arounds
that can be used within an ActiveX script to verify actual step
Failures vs. those that did not run? Thanks.

#2

What about

for each stp in DTSGlobalVariables.Parent.Steps
MsgBox stp.Name & " : " & Cstr(stp.StartTime)
Next

The not run step should have a time of 00:00:00

--
--

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

"dcsi" <jc39ct (AT) hotmail (DOT) com> wrote

Quote:

If a package has several steps and some of these do not run by design
(e.g. they only run if a specific step fails) then looping through the
steps checking for status as suggested in other posts does not always
help:

opkg.execute
Steps_Success = True
for each ostep in opkg.step
if ostep.Executionresult = DTSStepExecResult_Failure then
Steps_Success = False
end if
next
if Steps_Success = False then... ' take some appropriate action

The Executionresult property only returns Success or Failure. Any step
that "was not executed" returns Failure. Are there any work-arounds
that can be used within an ActiveX script to verify actual step
Failures vs. those that did not run? Thanks.

#3

Excellent! Thanks Allan, that does the trick. The time after the Cstr
conversion actually comes back as "12:00:00 AM", easy enough to check
for.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

What about

for each stp in DTSGlobalVariables.Parent.Steps
MsgBox stp.Name & " : " & Cstr(stp.StartTime)
Next

The not run step should have a time of 00:00:00

--
--

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

"dcsi" <jc39ct (AT) hotmail (DOT) com> wrote in message
news:77a44de7.0409070704.50acaf46 (AT) posting (DOT) google.com...
If a package has several steps and some of these do not run by design
(e.g. they only run if a specific step fails) then looping through the
steps checking for status as suggested in other posts does not always
help:

opkg.execute
Steps_Success = True
for each ostep in opkg.step
if ostep.Executionresult = DTSStepExecResult_Failure then
Steps_Success = False
end if
next
if Steps_Success = False then... ' take some appropriate action

The Executionresult property only returns Success or Failure. Any step
that "was not executed" returns Failure. Are there any work-arounds
that can be used within an ActiveX script to verify actual step
Failures vs. those that did not run? Thanks.

#4

That does the trick as well! Thanks again.

"Sreenath" <Sreenath (AT) discussions (DOT) microsoft.com> wrote

Quote:

Probably you check first the status of the step, whether it is
completed...then you can test for success or failure. If its not completed,
that means that step didn't run. Don't worry about that step. Or viceversa.

"dcsi" wrote:

If a package has several steps and some of these do not run by design
(e.g. they only run if a specific step fails) then looping through the
steps checking for status as suggested in other posts does not always
help:

opkg.execute
Steps_Success = True
for each ostep in opkg.step
if ostep.Executionresult = DTSStepExecResult_Failure then
Steps_Success = False
end if
next
if Steps_Success = False then... ' take some appropriate action

The Executionresult property only returns Success or Failure. Any step
that "was not executed" returns Failure. Are there any work-arounds
that can be used within an ActiveX script to verify actual step
Failures vs. those that did not run? Thanks.

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

DTS Package Execute - Checking status of steps

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

DTS Package Execute - Checking status of steps - 09-07-2004 , 10:04 AM

Re: DTS Package Execute - Checking status of steps - 09-07-2004 , 02:08 PM

Re: DTS Package Execute - Checking status of steps - 09-08-2004 , 10:18 AM

Re: DTS Package Execute - Checking status of steps - 09-08-2004 , 10:35 AM