SSIS (Sql server Integration Services)

Ø  It is an ETL tool

Ø  It is used to perform ETL process

Ø  It supports to work with RDBMS, Flat File, Excel File, XML files etc….

Ø  It provides set of transformation object for implementing required business logic

Ø  It supports to work with Native Sql

Ø  It provide script component and script task to design business logic in C# or VB.Net

Ø  It Support to access the DB object from the database

Ø  Support to work with multiple files.

Ø  It support scheduling

Ø  Support Error handling

Ø  Support Event handling

Ø  Provide the slowly changing dimension transformation object to implement the SCD 0, SCD 1 and SCD 2.

Ø  Support to build and deploy (May be Package or Project)

Ø  Support Import and export.