Transporting data from a source to its destination. The primary purpose of the data flow task is to move data from a source to a destination. Also, in the data flow is where transformations are performed. Moving data and transforming it constitutes the bulk of ETL (Extract-Transform-Load) work done in a BI solution. A package’s…

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…

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…

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…