April 9th, 2010 by aabhaanjan

SSIS: – SSIS is most important part of Sql Server 2005 . SSIS is the way to transfer the data from one source to another source .SSIS is robust way to load data or transfer the data from different source and perform tasks in a workflow.

Architecture of SSIS

The SSIS Architecture consists of four main components

  1. The SSIS Services
  2. The SSIS runtime engine and the runtime executables
  3. The SSIS data Flow engine and the data flow components
  4. The SSIS clients

SSIS Package:

When we are creating SSIS package .You will get following object in Solution Explorer. The solution explorer window consist SSIS package, connection or Data Sources and data source views. The Screen is given below


  1. Data Source :- Data source basically is connection that can be used for source or destination to transfer the data . Process to create Data Source
  2. Data Source Views (DSV):- Data Source views allow you to create a logical views of your data. Basically Data source views are collection of tables , views , stored procedure and queries that are shared across our projects .DSVs are deployed as a connection manager.
  3. SSIS Packages :-A Package is a collection of tasks that execute in orderly. SSIS Packages basically provide the user interface to transfer the data from one source to another source They can be used to merge data from heterogeneous source or transfer data from heterogeneous data source .The primary use for SSIS packageĀ  is flexible tool for data extraction , transformation and loading (ETL).This is an important part of data warehousing .

The tool also used to update multidimensional cube data

Tags: , , , , ,