Data Warehouse using MSSQL - SSIS : Installation best practices RRS feed

  • Question

  • Hi All,

              I am working on a MSSQL - 2008 R2 , based data warehouse building.  The requirement is to read source data from files, put it in stage database and perform data cleansing etc .. and then move the data to data warehouse db .. Now the question is about the required number of physical servers and in which server which component (MSSQL , SSIS ) of MSSQL should be installed based on any best practices:

    Store Source files --> Stage database --> data warehouse db

    The data volumne will be high ( per day 20 - 30 k transactions) ... Please suggest

    Thank you


    Wednesday, January 1, 2014 7:02 AM