Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Please Consider this scenario:

I have a table in my database. I want move this data in my OLAP database using SSIS.I can move all record from my table to OLAP database.The problem is I don't know how I can apply changes in OLAP environment.For example if just 100 record of my table were changed how I can apply this changes NOT copy all records from scratch.

How I can Merge this two tables?


share|improve this question
Have a look at Change Tracking and Change Data Capture. – Jon Seigel Feb 25 '14 at 19:29
Table -> Olap You need to identify the rows in Table that don't exist in Olap. Are you only looking for rows that don't exist in Olap or do you need to factor in whether the value has changed in Table and that's not reflected in Olap. If someone changed a value in Olap, you have a conflict - now what? What about a deleted row from Table that exists in Olap, does the solution need to factor this into the equation? What version of SQL Server are your source and destination. What are the data volumes and expected delta volumes? – billinkc Feb 26 '14 at 16:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.