Audit Transformation


The Audit transformation enables the data flow in a package to include data about the environment in which the package runs. For example, the name of the package, computer, and operator can be added to the data flow. Microsoft SQL Server Integration Services includes system variables that provide this information.

The following table describes the system variables that the Audit transformation can use.

System variableIndexDescription
ExecutionInstanceGUID0The GUID that identifies the execution instance of the package.
PackageID1The unique identifier of the package.
PackageName2The package name.
VersionID3The version of the package.
ExecutionStartTime4The time the package started to run.
MachineName5The computer name.
UserName6The login name of the person who started the package.
TaskName7The name of the Data Flow task with which the Audit transformation is associated.
TaskId8The unique identifier of the Data Flow task.

You configure the Audit transformation by providing the name of a new output column to add to the transformation output, and then mapping the system variable to the output column. You can map a single system variable to multiple columns.

This transformation has one input and one output. It does not support an error output.

You can set properties through SSIS Designer or programmatically.

For more information about the properties that you can set in the Audit Transformation Editor dialog box, see Audit Transformation Editor.

The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:

For more information about how to set properties, see Set the Properties of a Data Flow Component.