splitthird
MIS
I know how to create branches in the path that are based on success and failure which can be set in Activex scripts. However that always leaves a failure when the DTS package executes (even though it has worked perfectly).
How do I get a branch without a failure showing when the DTS is run.
The scenario is the DTS is looping through some steps and checking at the start of the loop that a global variable is less than the number of records read earlier. When this fails I then have a step that creates the indexes and I am then done. But the failure isn't helpful as it shows the whole package as failing when in reality it is fine.
What is the answer?
How do I get a branch without a failure showing when the DTS is run.
The scenario is the DTS is looping through some steps and checking at the start of the loop that a global variable is less than the number of records read earlier. When this fails I then have a step that creates the indexes and I am then done. But the failure isn't helpful as it shows the whole package as failing when in reality it is fine.
What is the answer?