question

Thaya avatar image
Thaya asked

How to Log New Value and updated value in SSIS

I am using Lookup transformation to check the match and unmatch records. For matching records i am doing Update with the SQL update statement in the SQL command . In my project, My ssis should capture the new and updated value once the update is over. it should be in the below format as a table. id, Columnname, Old Value , new Value . Please help me on this,
ssis
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I am fine with SQL script ( I dont want a trigger) or a C#.net code (i can use in Script component)
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.