How to use Audit component in SSIS

The Audit Transformation allows you to add auditing data to your Data Flow

The task is easy to configure. For example, to track what task inserted data into the table, you can add those columns to the Data Flow path with this transformation. The functionality in the Audit Transformation can be achieved with a Derived Column Transformation, but the Audit Transformation provides an easier interface.

Following are some of the available options:

• Execution instance GUID: GUID that identifies the execution instance of the package
• Package ID: Unique ID for the package
• Package name: Name of the package
• Version ID: Version GUID of the package
• Execution start time: Time the package began
• Machine name: Machine on which the package ran
• User name: User who started the package
• Task name: Data Flow Task name that holds the Audit Task
• Task ID: Unique identifier for the Data Flow Task that holds the Audit Task

Select Audit column will append in the Dataflow.

Cheers!
Uma