Source: "Bi thing" data stream conversion--audit
The audit transformation allows you to add audit audit data to the data flow, and in the past when using Hippa and Sarbanes-oxley (SOX), you must keep track of who inserted the data at what time, and the audit transformation can implement this capability. For example, to track that task to insert data into the table, you can add the appropriate columns in the audit transformation. In the output Column Name column, enter the column that you want to audit, and in the audit type, select the type of audit that you can select:
- Execution Instance Guid:guid Marking is the insert operation performed by that package
- The only indication of Packageid:package
- Packagename:package's name.
- Versionid:package version of the GUID
- Executionstarttime:package time to start execution
- Machine name where the Machinename:package is located
- UserName: User who started the package
- TaskName: The name of a task in the data stream
- TaskID: The name of the data Flow task that contains the transform task
"Bi thing" data stream conversion--audit