SSIS

SSIS – SQL Server Integration Services and is a component of the Microsoft SQL Server database software that can be used to solve complex business problems by copying and then loading data warehouses by cleansing and mining data and managing SQL Server objects and data.

Integration Services features a data warehousing tool used for data extraction, transformation, and loading (ETL), where the tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

They can extract and transform data from a wide variety of sources such as XML data files, flat files and then load the processed information into an enterprise data warehouse or other target systems. It has set of tools for developing and testing integration programs, called SQL Server Data Tools, plus a server component for deploying and running the programs.

Integration Services Includes;

1.Rich set of built-in tasks and transformations

2.Graphical tools for building packages

3.Integration Services Catalog database;

4.In which you store, run, and manage packages.