Encountering some odd behavior inside of a DTS package.

The package itself is very simple:

The first step copies data into a temp table. If that step fails, it sends
an e-mail to a list of recipients. If it succeeds, it goes to the next step,
which is to populate the "real" table. If that succeeds, onto the next step.
If not, an e-mail is sent.

Lst night someone went in and changed the name of the destination table, so
the load of the "real" table fails because of invalid object name. The thing
that stinks is that even though the step fails, the send mail step is not
being executed.

I don't get it...

Any help would be appreciated!

Thanks!

Are you logging execution?
I suspect this failed validation and nothing got executed at all.

Maybe you should send the email on failure of the package rather than
failure of a step.

www.nigelrivett.net


*** Sent via Developersdex http://www.developersdex.com ***

It doesn't look like it's a validation issue. I checked the logs:

The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Package failed because Step 'DTSStep_DTSExecuteSQLTask_3'
failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700


Package Name: Load VDN_ROUTE
Package Description: (null)
Package ID: {ED69E76D-2C91-413E-A16D-8D2FDA46486F}
Package Version: {5E8DCDF7-55D3-4352-9B2C-41A8BAE9D665}
Package Execution Lineage: {67AE3C62-D002-4F96-A415-565275FE91F2}
Executed On: MSP-RGRA
Executed By: DB.admin
Execution Started: 10/18/2006 10:28:00 AM
Execution Completed: 10/18/2006 10:28:08 AM
Total Execution Time: 7.625 seconds

Package Steps execution information:


Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step Execution Started: 10/18/2006 10:28:00 AM
Step Execution Completed: 10/18/2006 10:28:08 AM
Total Step Execution Time: 7.578 seconds
Progress count in Step: 100025

Step 'DTSStep_DTSExecuteSQLTask_1' was not executed

Step 'DTSStep_DTSExecuteSQLTask_2' was not executed

Step 'DTSStep_DTSExecuteSQLTask_3' failed

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Invalid object name 'VDN_ROUTE'.
Step Error code: 80040E37
Step Error Help File:
Step Error Help Context ID:0

Step Execution Started: 10/18/2006 10:28:08 AM
Step Execution Completed: 10/18/2006 10:28:08 AM
Total Step Execution Time: 0.047 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_4' was not executed

Step 'DTSStep_DTSExecuteSQLTask_5' was not executed

Since Step 3 failed, Step 4 should have been executed.

Dumb question: how do you fail on the entire package versus just one step?

Thanks!


"nigelrivett" wrote:

....also

The other e-mail step works just fine - if the step completes, it sends a
success notification...

"A. Robinson" wrote: