Scheduled packages not executing

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



I am rather new to DTS, and the problem I have seems to be rather odd.
I have a scheduled DTS Package (say Pkg-S) that simply executes a bunch
of other packages sequentially based on the workflow properties.

Pkg-S executes Pkg-A, Pkg-B and Pkg-C first.
Then, on success of Pkg-A, Pkg-D is executed, on success of Pkg-B,
Pkg-E is executed, and on success of Pkg-C, Pkg-F is executed.
So basically I want all the packages (A to F) to execute given that the
respective predecessor packages executed successfully.

The problem is, on schedule, Packages A to C execute without error,
however, Packages D to F don't even get started.

All packages executed without problem through the designer, and the
package log as well as the job log shows no errors. For testing
purposes I even added a simple package that would insert a field to a
table and set this package to execute "On Fail" for Pkgs A to C, and
even that does not seem to execute. In other words, Pkgs A to C seem to
neither complete successfully, nor fail, as far as the workflow is
concerned. And according to the logs, they complete without the
slightest problem.

None of the options about "Fail package on step fail", etc have been
turned on, and logging on the server is turned on for all packages.

Any help would be greatly appreciated.

.



Relevant Pages

  • Re: Cannot execute DTS package
    ... > "Hermit Dave" wrote in message ... >> Whats happening is that it is trying to execute the Query with context ... >>> executing DTS packages from the ASP.NET: ... >>> String ServerPassword, DTSSQLServerStorageFlags Flags, String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot execute DTS package
    ... > "Hermit Dave" wrote in message ... >> Whats happening is that it is trying to execute the Query with context ... >>> executing DTS packages from the ASP.NET: ... >>> String ServerPassword, DTSSQLServerStorageFlags Flags, String ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: [fw-wiz] Securing a Linux Firewall
    ... If you can execute shell code, ... programs the firewall needs and only put those on the jumpstart CD". ... This means removing all unused packages from the system before creating ... - audit time. ...
    (Firewall-Wizards)
  • [Full-disclosure] [ MDVSA-2010:091 ] openoffice.org
    ... Affected: Enterprise Server 5.0 ... An integer underflow might allow remote attackers to execute arbitrary ... Further packages were provided to supply OpenOffice.org. ... Mandriva Enterprise Server 5/X86_64: ...
    (Full-Disclosure)
  • [ESA-20030219-003] Several PHP vulnerabilities
    ... Secure Network to update their systems automatically. ... execute the command: ... To verify the signatures of the updated packages, ...
    (Bugtraq)