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 |
|
kellog1
Starting Member
35 Posts |
 Posted - 2010-05-05 : 10:34:38
|
| Guys,Currently I am running a nightly job to get full refresh of data source database into the destination database. But I would like to do incremental update based on the below logic.Since we are using timestamp in both source and destination, I would like to compare source timestamp with destination timestamp and if source timestamp is greater than destination timestamp then goto next task else exit.Can anybody out there tell me how to achieve this SSIS? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-05 : 14:53:07
|
| create a variable in package and get value as MAX(timestamp) from destination in a Execute sql task and store it in variable. then in a DFT use OLEDB source and extract from source all data with timestamp > variable. then use that data for populating destination.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Conditional Control Flow Task