Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Incremental Load using complex query as data source

Incremental Load using complex query as data source

Incremental Load using complex query as data source

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?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close