SSIS Architecture:

SSIS _ Practical Architecture:

Solution (collection of Projects)

            -Project (collection of packages)

                        -Package (Collection of 1/more tasks)

Package:

1.      Contlow Flow Tasks

2.      Data Flow Tasks

3.      Package Explorer

4.      Event Handling

5.      Parameters ( Newly added in 2012 onwards)

Sollution Explorer Contains :

1.      Projects

2.      Packages

3.      DSVs

4.      Data Source Info

Data Source Info: is used to connect to the DB

            Data Source can be Reusable across the “packages”               

DSV : is a Logical Object for the Physical collection of tables/views in Data Sources

Conn_Mgrs: For every connection we can take a name that name can be ReUsable across the Program/pkg.

1.      In case of FLAT File : (File Conn_Mgr)

            Folders & the FileName taken as “Connection String” for the Conn_mgr

2.      In case of DB Source:  ( DB Conn_Mgr)

ServerName & DB_Name is taken as Part of “Connection String” in Conn_Mgr.