Inc Update of Dimensions using SSIS

Tech-Archive recommends: Speed Up your PC by fixing your registry

Dear all,

Just wondering if there is any way to perform incremental update of
dimensions using SSIS packages? The AS Processing task does not have
the option to specify "Incremental Update".

I know we can use proactive caching but our app architecture would
require the update to be done through an external means using SQL
Agent Job. Any other way to do this using Agent Jobs?

Any help is appreciated.

Thanks in advance.


Cheers,
Arun

.