hi,

I know how to load dimension data with type 1 as well as type 2. I want to know how to load fact tables through SSIS.

Is there any best examples or if there any example for Adv workDW.

I do not know why Microsoft did not provide package to load Adv WorksDW through SSIS pkg.