Tag Archives: Business Intelligence

SSRS reports examples for 2012

SSRS reports examples for 2012 I wanted to explore the different types of SSRS report hence I would be starting with a simple report. We’ll see creating SSRS report example in 2012. To have more meaningful format for reports I … Continue reading

Posted in MSBI, SSRS | Tagged , , , , , , , , , , | 1 Comment

Incremental Load in ssis with example

This post demonstrates the incremental load in SSIS with example. Based on the business requirement and data volume we should determine the ETL process. We’ll assume we have a low to mid-sized source data file and here are the requirements: … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , , , , , , , , , | 6 Comments

Using variables in SSIS packages

Using variables in SSIS packages Passing variables at Runtime – SSIS Requirement: We have got a request to design a package which needs to be take care of the below functionality. 1.  Every day we get data from a client. … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , , , , , , , , | 7 Comments