Audit(SSIS)

The Audit Transform allows you to add auditing data to your Data Flow. In the age of HIPPA and
Sarbanes - Oxley (SOX) audits, you often must be able to track who inserted the data into a table and
when. This transform helps you with that function.

The following are some of the options you ’ ll have available to you:

• Execution Instance GUID: The GUID that identifies the execution instance of the package
• PackageID: The unique ID for the package
• PackageName: The name of the package
• VersionID: The version GUID of the package
• ExecutionStartTime: The time the package began
• MachineName: The machine that the package ran on
• UserName: The user that started the package
• TaskName: The Data Flow Task name that holds the Audit Task
• TaskID: The unique identifier for the Data Flow Task that holds the Audit Task