Here’s a great explanation of how to do incremental loads in SSIS. It uses third-party components from Pragmatic Works, and a combination of hand coding and SSIS tasks.
See how complex it is? How long it takes?
Here’s how to do the same thing in Ajilius:
Simply check the box on the column/s that govern incremental change.
Under the covers we do almost exactly the same tasks as described in the blog post, but the difference is that we do them, not you. You make a decision in the UI, and we instantly generate all the code and logic that implements that decision.
That’s it … a perfect example of why Data Warehouse Automation kicks the crap out of great ETL tools like SSIS, and why we deliver data warehouses in a fraction of the time spent in those products.
Ajilius. Data warehouses. Faster.