RE: DTS package Precedence not working

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Les Russell (Russell_at_discussions.microsoft.com)
Date: 10/22/04 

Date: Thu, 21 Oct 2004 20:53:02 -0700

I came to the forum to ask this exact same question. Sorry I can't help, but
just so ppl know that there are a few interested parties.

"TCG_GILBERT" wrote:

> I have a master DTS package that is made up of multiple other DTS packages.
> The process that we run nightly is something like:
> Step 1 (pull data)
> On Success
> Step 2 (aggregate data)
> On Success
> Step 3 (generate key in separate table)
> On Success
> Step 4 (push data into final table)
>
> It's important that the package come to a hault if something goes wrong in
> step 3 as we don't want records in the table (step 4) that don't have
> corresponding records in the key table. Hence we put a workflow step in
> between each execute dts package task saying move to the next step "on
> success". However in observing the package execute it seems to move the next
> step regardless of the results in the prior step. If step 3 fails step 4
> starts going instead of aborting the master package?
> Wondering if this is a known issue? Any help would be greatly appreicated.
>
> I"m using SQL SERVER2k on a Win2k3 server.
> Thanks in advance.
> Josh

Relevant Pages

  • RE: DTS package Precedence not working
    ... I'll give it a shot tomorrow. ... > On Success ... > between each execute dts package task saying move to the next step "on ...
    (microsoft.public.sqlserver.dts)
  • Re: Install VS .Net 2003 error 1603
    ... The package program command-line is the same, ... It certainly reports back a success code and should also report back ... failure codes when the deployment doesn't go right. ...
    (microsoft.public.sms.admin)
  • Re: False success in Agent Job
    ... contains only 1 step which is to execute the package. ... You can also check thejobstep details in thejobhistory, ... Links for SQL Server Books Online: ... I tried to change the job step's "On success ...
    (comp.databases.ms-sqlserver)
  • Re: Advanced Client-will not install security updates
    ... > have run at least once on the client machines before you attempt to ... >> The advertisement status of this package reports back the following ... >> documentation for the program you are distributing. ... >> having success. ...
    (microsoft.public.sms.misc)
  • Re: Help uninstalling extra languages from Open Office
    ... any success at finding out how to *remove* the language pack, ... Reading the OO FAQ hasn't helped, ... I go about finding the name of the package? ...
    (Fedora)