Tag Archives: SSIS

Designing a simple SSIS package using SQL Server 2016

This post can help you to understand the “Designing a simple SSIS package using SQL Server 2016” and SSIS Project Deployment Model in SQL Server 2016. Project Deployment Model is introduced in SQL Server 2012 and provides more flexibility in … Continue reading

Posted in MSBI, SQL Development, SSIS | Tagged , , , , , , | 1 Comment

SQL DBA Interview Preparation

 SQL DBA Interview Preparation This post can help you in SQL DBA Interview Preparation. We blogged various pages and posts and SQL Server DBA Interview Preparation, this post is helpful to locate / link all the content that is useful … Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , , , , , | 4 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:

Insert sample data as below.

ETL requirement: Design a ETL package … Continue reading

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