Hi Guys,
I am pretty new in ssis. I have an unrgent requirment where i need to load a table in SQL server incrementaly. I have a complex query based on 3-4 table. I need to load query results incrementally (only new records, no tracking for update or delete.) Query results would be very heavy
following are the requirement
1- Loaded table should maintain last 40 days data (each day oldest 41th day data would be purged), wont keep records older than 40 days
2- Query will bring only incrmental record, if any new record query brings will load in table
I can not use CDC. can not use indivudual tables as data source only the query.
What can be the best approach/solution. Any help please?
Thanks
I am pretty new in ssis. I have an unrgent requirment where i need to load a table in SQL server incrementaly. I have a complex query based on 3-4 table. I need to load query results incrementally (only new records, no tracking for update or delete.) Query results would be very heavy
following are the requirement
1- Loaded table should maintain last 40 days data (each day oldest 41th day data would be purged), wont keep records older than 40 days
2- Query will bring only incrmental record, if any new record query brings will load in table
I can not use CDC. can not use indivudual tables as data source only the query.
What can be the best approach/solution. Any help please?
Thanks