TechNet
Export (0) Print
Expand All

Audit Transformation Editor

 

Applies To: SQL Server 2016

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. Integration Services includes system variables that provide this information.

To learn more about the Audit transformation, see Audit Transformation.

Output column name
Provide the name for a new output column that will contain the audit information.

Audit type
Select an available system variable to supply the audit information.

ValueDescription
Execution instance GUIDInsert the GUID that uniquely identifies the execution instance of the package.
Package IDInsert the GUID that uniquely identifies the package.
Package nameInsert the package name.
Version IDInsert the GUID that uniquely identifies the version of the package.
Execution start timeInsert the time at which package execution started.
Machine nameInsert the name of the computer on which the package was launched.
User nameInsert the login name of the user who launched the package.
Task nameInsert the name of the Data Flow task with which the Audit transformation is associated.
Task IDInsert the GUID that uniquely identifies the Data Flow task with which the Audit transformation is associated.

Integration Services Error and Message Reference

Community Additions

ADD
Show:
© 2016 Microsoft