Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2011-09-09 : 15:36:14
|
| Hi guys, I am trying to fix the issue that i have, My package is 1) Flat File Source 2) Derived Column Transformation 3) Data Conversion Transformation 4) Slowly Changing Dimension (SCD) My requirement is I want to trak if there is any update and new entry here is my Traking Table structure Entry Date = When Changes made "could be GETDate()" Field_Changed = Which field change(TableName.ColumnName) New_value = what is new value if change or new entry Old_Value = What is old value Please help me out to accomplish this task. I know option whould be CDC (Never use it). Any advise would be great help for me. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-10 : 01:08:43
|
| isnt it a matter of implementing a trigger on your main table and capture the details in tracking table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2011-09-12 : 10:29:38
|
| You are right, something like this that! My whole project in SSIS. If anyone can help me or guide me how i can start it would be great. Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-09-12 : 10:56:27
|
| Some ideas here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170215 |
|
|
|
|
|
|
Capture Changes