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 this will truncate every day and load the data from other Source.

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

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

    Tuesday, December 14, 2010 11:13 PM


All replies