Q Lab

Import data from multiple Excel files using SSIS

SSIS Tutorials - In this interesting post, we will learn how to import data from multiple Excel files to a single destination say, SQL Server using SSIS. This question is asked in many MSBI interviews and also by many followers, so the wait is over. Let me explain the scenario to understand this problem. Suppose, there is one folder and on a daily basis data is kept in separate Excel files in this folder. Now, you are asked to extract the data from this folder containing multiple Excel files to…
Click to Learn »
SSIS

SSIS Merge Transformation explained with example

Aim :-  This post under SSIS Tutorial category will enlighten you with a very interesting transformation Merge transformation in SSIS. In this article we will learn about the Input requirements, working and Configuration of SSIS Merge transformation. Description :-  Listening the term “MERGE”, it sounds like combining something. In SSIS, this something is Data which comes from various sources (can be of same type or heterogeneous). After configuring Data sources, we will Combine/Merge the data from these data sources to generate a final single output. In other words, Merge transformation combines…
Click to Learn »
Home

SSIS Precedence constraint – Success, Failure and Completion

Aim :-  Today, we are going to watch and learn a very interesting thing in SSIS Precedence Constraints. They are like Soldiers of a country, very important and essential yet no limelight. Moreover, they don’t feel bad for no recognition of their work. Description :-  In SSIS package, Precedence constraints are the arrows in a Control flow which is responsible for connecting the tasks together. Additionally they also manage the order in which the various tasks present in the control flow will execute. One very awesome characteristic of Precedence constraint…
Click to Learn »
Q Lab

How to Execute SSIS package using Microsoft Excel macros

Once you develop an SSIS package, what is the next step that you will perform? The next step definitely will be to schedule or execute that package. We all are smart and know very well that we can execute the package directly from SSDT (SQL Server Data Tools). But, today I will show you How to Execute an SSIS package using Microsoft Excel. It is quite useful in some project scenarios and also fun to learn (if not required in your project) a new way for SSIS package execution. Scenario…
Click to Learn »
Q Lab

Difference between Non, Semi and Fully-Blocking Transformations in SSIS

Aim :  This post is specifically written to understand difference between Non-Blocking transformations, Semi-Blocking transformations and Fully-Blocking transformations in SSIS ( SQL Server Integration Services). Have you ever thought about the behavior and working of the different transformations used in SSIS? Let’s read this article to understand better, if there is any method to recognize transformation category types and inner working of the SSIS transformations. Description :  In SSIS, we have 2 very important panes - Control flow pane and Data flow pane. Control flow acts as a brain of an…
Click to Learn »
SSIS

Implementation of Multicast Transformation in SSIS

Aim -  We have composed this article keeping in mind beginners who are searching Internet to learn Multicast transformation in SSIS. This post will take you through different steps which can be required to Configure SSIS Multicast Transformation. We have tried our best to explain this in very simple language and by taking an easy example. Let's learn this SSIS transformation practically. Description - Definition - Multicast Transformation in SSIS is used to distribute every Input row to every row in one or more Outputs. Where to Find -  You can find SSIS Multicast transformation in…
Click to Learn »
Q Lab

Conditional Split Transformation in SSIS

Aim :  This article is written keeping in mind the intention of visitors who wants to learn in depth about Conditional Split transformation in SSIS. Description : Definition - SSIS Conditional Split Transformation as the name suggests split the data based on conditions. In other words, it can route the source data into different places/destinations based on the conditions we mention while configuration of this component. You can think of CASE statement in programming. Where to Find - You can find Conditional slit transformation in Data flow level for the…
Click to Learn »
Home

Learn SSIS Derived Column Transformation

Aim :- Earlier tutorials were targeted to provide insight on various transformations in SSIS. Continuing with the same approach, today we are going to learn one more SSIS Transformation named as Derived Column Transformation. We fill follow our traditional method Learning things via doing them practically. This always gives a better vision of the concept. Description :-  Read this loudly - SSIS Derived Column Transformation. The name itself indicates that it is going to derive something from column(s). If this thing came to your mind then you hit the bulls…
Click to Learn »