Best method for incremental fact load (inserts and updates) using SSIS

[manbat]

I am aware that SSIS has SCD component which can be used to determine insert/update strategy.

When loading a fact table (incrementally), can we use the same SCD component or is there a better way to load fact tables?

[selvaraman]

You can use T-SQL Merge Statement if possible

[TheNJDevil]

Why would you want use the SCD on a fact table? Fact tables should be mostly inserts with virtually no updates (of course there are exceptions). I've just separated out the pure fact insert flow from the update flow and everything seems to run smoothely.