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 |
|
abhram
Starting Member
3 Posts |
 Posted - 2007-11-29 : 06:35:02
|
| Hi,I am trying to create a SSIS package, which will extract data from a SQL server view and populate the data in our local SQL server database tables. My objective is to get the data from the view such that only inserted and updated rows are fetched from the view.Note: the view does not expose any updated date type of column thru which I can check. So I guess I have to compare each and every field with my destination table row's fields.I would appreciate any suggestions on how to approach the problem.Thanks in advance. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-29 : 08:30:44
|
| Looks like you will have to compare each field if you do not have a date to work with. |
 |
|
|
|
|
|
Fetch only inserted and updated rows from source