Analytics in Action

Introduction to the Basics of SQL Server Integration Services (SSIS)

Oct 17th in Data Integration by admin

3

In this post I give an overview  of  SQL Server Integration Services (SSIS). I cover 1) What is SQL Server Integration Services (SSIS)? 2) Why use Extract Transform Load (ETL) tools like SSIS? & then discuss  3)The basic building blocks of an Integration Services package. These building blocks include Connection Managers and transformations such as Merge Joins, Sorts, Data Conversions, Aggregates, Conditional Splits, Union All, Pivots, Unpivots and Multicasts. I also demonstrate how these building blocks are linked together in a live SSIS package. To wrap things up I then outline a few helpful resources for learning SSIS.

Related posts:

  1. Multicast transformation in SQL Server Integration Services (SSIS)
  2. An introduction to using Variables in SSIS packages
  3. How to build a SQL Server Integration Services package.
  4. Using Merge Join Transformations in SQL Server Integration Services (SSIS).
  5. Unpivot transformation in SQL Server Integration Services
« »

admin

3 Responses to “Introduction to the Basics of SQL Server Integration Services (SSIS)”

  1. Mike
    Oct 19th

    Interesting fact. thanks for the info!

    Reply
  2. Eddy
    Oct 19th

    Hello!I am checking your blog for some weeks now. I have to admit that it is very informative. It is added in my favourite list and i will try to follow it frequently. Thanks for the interesting inputs . Moreover , i really like your theme and the way you have organised your site . Could you the name of your template ? Cheers

    Reply