Category Archives: MSBI

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: CREATE TABLE Product_Sales_History( SaleID BIGINT NOT NULL UNIQUE, ProductID VARCHAR(50) NOT NULL, Total … Continue reading

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

Deploying SSIS package using Deployment Manifest with screenshots

The post Deploying SSIS package using Deployment Manifest with screenshots can help you to deploy SSIS package using deployment manifest. To demonstrate this I have created a simple ETL package to load data from a Flat file to SQL Server … Continue reading

Posted in MSBI, SQL Server DBA, SSIS | Tagged , , , , , , , , , | 11 Comments

Drill Down Reports in SSRS with examples

Drill Down Reports in SSRS with examples We will see how to deal with drill down reports in SSRS with examples. For this report you can create a table and populate data from the post. Let’s create a report using … Continue reading

Posted in MSBI, SQL Development, SQL Server DBA, SSRS | Tagged , , , , , , , , , , , | 5 Comments