473,383 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

DTS workflow problem when encountering On Failure

I am creating a DTS package in SQL Server 2000.
I am importing a text file : on success the workflow will continue and
run SQLTask A and then SQLTask B
On Failure I am executing an activeX script to try and exec only
SQLTask B.

When the import fails it simply stops on the activeX task and does not
continue...

Here is the script:

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Option Explicit

Function Main()

'** Do Not Run this step
dim oStep
Set oStep = oPkg.Steps("DTSStep_DTSExecuteSQLTask_1")
oStep.ExecutionStatus = DTSStepExecStat_Inactive

'** Run the following step
dim stpGo
Set oPKG = DTSGlobalVariables.Parent
set stpGo = oPkg.Steps("DTSStep_DTSExecuteSQLTask_2")
stpGo.ExecutionStatus = DTSStepExecStat_Waiting

Main = DTSTaskExecResult_Success
End Function

I've used this logic before but never after a failure.
Any help would be appreciated.
Jul 20 '05 #1
0 1741

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Paolo Losi | last post by:
Hi all, I'm pretty new to the python language so please excuse me if this is FAQ... I'm very glad to be part of the list! :-) I'm looking into a way to implement a generic workflow framework...
0
by: Bevertec | last post by:
May 26 2004 Our client is a major bank in Jamaica and they have a contract requirement for a professional with the following skills. This is a 6 months contract. It would be 3 weeks/month in...
0
by: Yatendra Khandelwal | last post by:
hi, I am a newbie to this (exchange server and workflows) and I am trying to create a test workflow app using workflow designer (office developer) and exchange 2003. I have created a workflow...
1
by: ABC | last post by:
My client request a workflow solution. They want the solution provide as: 1. Has a workflow diagram interface presents their roles, work and tasks. 2. Support .NET technologies for developers to...
1
by: Urs | last post by:
Hi What happens to workflow references to objects outside the workflow class instance, when passivating a workflow, having SqkWorkflowPersistenceService enabled? Example: Let's say my...
3
by: Claudia Fong | last post by:
Hi I was using a console application to host the windows workflow and when I change to winforms, I don't know how to do it... I pass the parameters into the workflow from the winform and is...
3
by: =?Utf-8?B?R3JhaGFt?= | last post by:
I've added 2 tracking services to the wf runtime; one is the standard SqlTrackingService: trackingService = new SqlTrackingService(<trackingConnectionString>); <workflow...
0
by: RoninZA | last post by:
Hi all, My problem is this... I need to somehow communicate the completion of a workflow back to the calling application. The scenario is as follows: I have a "generic" workflow engine,...
1
by: =?Utf-8?B?bGludXgyazg=?= | last post by:
Hi, I'm testing Web Approval Starter Kit with Visual Studio 2005 over Windows XP SP2, .NET Framework 3.0 & 3.5 versions installed. When try to complete an activity, the following error...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.