SSIS: An Overview of Control Flow

A brief introduction of Control Flow. Control Flows represent one of the most important aspects of an SSIS package because their logic controls its execution. Control Flow are made up of: Tasks: These are objects that contain steps to perform (Data Flow, FileI/O, scripting). The main categories of tasks are: Workflow Tasks such as Execute…

SSIS: SQLServer to DataReader

Exporting SQL Server to a DataReader. In this article, I will demonstrate using SSIS to connect to SQL Server, export data from a table into a DataReader. When we’ve completed this tutorial, you should see the above screen. First, drag a DataFlow task unto the Control Flow designer. Next, double-click the DataFlow task which will…

SSIS: Commenting

Commenting (Annotating) your SSIS Package. In this article, I will discuss what might be one of the most overlooked aspects of all development project – commenting. The example above is taken from a mildly-complex complex where I connect to SQL Server and export data from a table into a DataReader while providing two DataViews for debugging (read SQL…

SSIS: An Overview

What is SQL Server Integration Services (SSIS) SSIS is Microsoft newest ETL platform. SSIS is a successor not an upgrade of DTS. The primary purpose for SSIS is to migrate and manipulate data in support of the Business Intelligence (BI) lifecycle (SQL Server, SSIS, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS). SSIS…