Latest DTS Package Log

This script returns the latest package log for the DTS package specified in the @package_name variable.  The interface for viewing DTS package logs through Enterprise Manager is limited in the fact that it doesn't provide textual descriptions of the values for the Step Execute Status and Step Execute Results.  This makes it difficult to trace what caused a package error.  This script will also return the number of rows effected by data transformation tasks, which is not available through Enterprise Manager.

Run this script while waiting for a scheduled package to execute to view the package progress.  We use this script to save run results to a file.

This script will only return results if DTS Package logging has been enabled on the Logging tab of the package properties.  The server this script is run from must be the same server specified in the package logging properties of the package.