none
Loading data from Staging to reporting tables RRS feed

  • Question

  • Hi I need to load the Reporting schema Tables every day from Staging tables Using SSIS.What is best way to load from staging..

    Lets say example Staging.loan this will truncate every day and load the data from other Source.

    Now i need to load the Report.loan every day from Staging.loan with out truncating the Report.loan .

    I need to Update the old records and Insert the New records...as some Records in Source will update every day like Amounts...

    Tuesday, December 14, 2010 11:13 PM

Answers

All replies