SQL Server Integration Services
SQL Server Integration Services or SSIS is an ETL server product and is integrated into Microsoft SQL Server 2005, 2008, 2012, 2014 and 2016 in the versions "Standard", "Professional" and "Enterprise". It consists of a Windows system service, an administration console and a developer product (SQL Server Business Intelligence Development Studio, or SQL Server Data Tools).
SSIS is the successor to Data Transformation Services (DTS).
use
SSIS is suitable when data from one database has to be regularly read, transformed and written to another database.
A typical example is to transfer changes to a normalized database, which enables rapid updates to the data entries ( records ), to a denormalized database, which enables the data to be read out quickly.
Web links
- SQL Server Integration Services. In: MSDN. Microsoft, accessed July 18, 2014 .