Can I define a step to be always executed as the last step of a package? I
want to log the error status of each other step in a database table. I know
that the package itself looks at the final status of all the steps at the end
and issues a message for each failure, but I want to write the same info to a
table for historical purposes.

I thinkI could put an "on completion" from every step to my error reviewer
step, but that means a very messy diagram for what seems like a logical
housekeeping task, like part of a destructor.
--
Thanks and Good Luck.
Fergus

Hello Fergus,

If I understand this correctly, you'd like to define a common error
handling step in a package to dump error information to database. If I'm
off-base, please let me know.

As I know, this feature is not avaialble in SQL Server. However, you could
enable DTS pacakge logging to log all error/failures and executions. In DTS
package design window, click Package->Properties->Logging

You could use following query to get the dts log information:

USE MSDB
SELECT * FROM sysdtssteplog

Also,you could get error information from error file.

If you have further concerns, please let's know.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Fergus,


Are you using DTS or SSIS


In SSIS the package's event handlers fire for the same event handler in its
tasks. You could look at the SourceName property to find out which executable
fired the handler.

In DTS to have something fire at the end of a package would be to use Workflow.
If you fired the package programmatically you could retrieve what happened
in the package.



Allan


[quoted text, click to view]