Tag Archives: SQL Server 2008 R2

Using variables in SSIS – Simple example

Using variables in SSIS – Simple example Working with variables in SSIS: A simple demonstration Before building the ETL package we need create a sales history table:

Insert sample data as below.

ETL requirement: Design a ETL package … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , | Leave a comment

Cumulative Update 7 has been released for SQL Server 2008 R2 SP2

Cumulative update package 7 for SQL Server 2008 R2 SP2 Click here to know the hotfixes in this CU Download the CU7

Posted in Miscellaneous | Tagged , , , | 2 Comments

How to Configure SSRS 2008 R2

How to Configure SSRS 2008 R2 How to Configure SSRS 2008 R2 Introduction: This post helps you understanding how to configure SSRS 2008 R2 service. Installation is nothing much difficult, we can just choose SSRS in features list while installing … Continue reading

Posted in MSBI, SQL Server DBA, SSRS | Tagged , , , , , , , , , | Leave a comment