Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incremental Load using complex query as data source

Status
Not open for further replies.

BTrees

IS-IT--Management
Aug 12, 2006
45
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top