473,729 Members | 2,405 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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("DTS Step_DTSExecute SQLTask_1")
oStep.Execution Status = DTSStepExecStat _Inactive

'** Run the following step
dim stpGo
Set oPKG = DTSGlobalVariab les.Parent
set stpGo = oPkg.Steps("DTS Step_DTSExecute SQLTask_2")
stpGo.Execution Status = DTSStepExecStat _Waiting

Main = DTSTaskExecResu lt_Success
End Function

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

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

Similar topics

6
4188
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 with python. The basic idea is to use python scripts as the way to specify workflow behavior. The framework should not only use scripts as a specification language but is going to leverage on python interpreter for the execution of the scripts. One...
0
1620
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 Jamaica and 1 week back home. All expenses including travel, accomodation (5 star) and meals would be taken care of. There would also be a per diem and a bonus at the end of contract. Oracle Consultant – Workflow
0
1267
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 system account and added it to exchange domain server group and set it as the identity that workflow event sink takes. also i have added this account and my account to the both the required roles in the windows event sink COM+ application on the...
1
907
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 enhance. 3. Has a workflow design to implement or modify the workflow sheets 4. Workflow Backend engine optional. I known Microsoft has Microsoft Windows Workflow Foundation. But I don't know it meet our client requirements or not.
1
1337
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 workflow holds a reference to a class instance in the host. A workflow is waiting for a few days. In the meantime, the machine is rebooted. I understand that the persistence objects come back to life, and my particular workflow will continue waiting.
3
2553
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 work fine, but I try to output something from my workflow to the winform that's when the problem arise... I know that I can write this code line in my workflow code so I can
3
2517
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 Runtime>.AddService(trackingService); trackingService.IsTransactional = false; trackingService.UseDefaultProfile = true; This works just fine.
0
1678
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, utilising Windows Workflow Foundation. This part works fine, no hassles. The idea of the workflow engine is that we can integrate a workflow authorisation process easily into any application with minimal work. The problem lies in the "generic" part...
1
4576
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 araises: System.InvalidOperationException was unhandled by user code Message="Workflow with id \"47773eee-c181-44a9-b045-30f5b7b1de51\" not
0
8921
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9427
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9284
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9202
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9148
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6722
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4528
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3238
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2165
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.