Thanks,

Syed

I want to capture history record from the CDC table but as you said it is in-consistent, only one table get updated out of three table, its very difficult to...

Uncheck the Materialize option in the Dimension Designer Tab will solve your problem

Uncheck the Materialize option in the Dimension Designer Tab will solve your problem

Uncheck the Materialize option in the Dimension Designer Tab will solve your problem

Try to reduce the package size and if you have used SCD transformation alter with lookup and conditional Transformation.

Thanks,

Syed

Before running the package set the package property Protection Level=DontSaveSensitive hope this would solve your problme,else reply back

---Syed

Before running the package set the package property Protection Level=DontSaveSensitive hope this would solve your problme,else reply back

---Syed

Before running the package set the package property Protection Level=DontSaveSensitive hope this would solve your problme,else reply back

---Syed