Category Archives: SSIS

Interview Questions

sql server experienced interview questions Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 ​ Organization … Continue reading

Posted in High Availability, Interview Q&A, MSBI, Performance Tuning, SQL Development, SQL Server DBA, SSIS, SSRS | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 68 Comments

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