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
|
1 comment:
I think you will not need a lookup transformation if you use SSIS Upsert. Although this is a third-party product but I still think it will be useful.
SSIS Upsert
Post a Comment