Mar 9, 2015

Audit Transformation SSIS simple example

What is audit transformation in SSIS?

Audit transformation is a component of the data flow task.   It is used to keep the auditing information of package in case of success or failure. This auditing information includes:
a. Execution instance GUID
b. Package ID
c. Package name
d. Version ID
e. Execution start time
f. Machine name
g. User name
h. Task name
i. Task ID

Configuration | Demo of Audit Transformation SSIS by very simple example step by step 1

Step 1: Create any source and destination transformations.
Step 2: Add audit transformation between source and destitution.
Step 3: Double click on Audit transformation.

SSIS Audit Transformation Example
Step 4: Run the package!!

Audit transformation demo 
Sample output:

ntUserID
Package name
Machine name
User name
Execution start time
1
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000
1
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000
1
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000
1
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000
2
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000
2
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000
2
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000
2
Package
RITESH-PC
Ritesh-PC\Ritesh
2015-03-09 08:43:17.000

No comments:

Post a Comment