developer.* Blogs - SSIS Design Technique: Sequence Container as Indirection Mechanism to Enable Flow - Comments

SSIS task constraints

Speedcat — Thu, 08 Feb 2007 15:18:39 -0800

Hi,

One way to get the "On Completion" constraint to continue executing the package is to do the following three:

1) Set task to not fail package on task failure
2) Set # of allowed errors on task to a very high number
3) Set the task to Delay Validation.

I know this is a brute way to get this done, but if you're doing a simple package it works and you're done with it.

SSIS Design Technique: Sequence Container as Indirection Mechanism to Enable Flow

Daniel Read — Sat, 28 Jan 2006 18:33:00 -0800

In my mind there are two separate but intertwined concepts at work in my hypothetical system: the "physical" concepts of execution and success and the "logical" concept of a "step" and whether or not the step "ran" (by which I mean, did the task or tasks that make up this step actually do any work).