Bi-kipedia
Microsoft SQL Server Integration Services
With the introduction of SQL Server Integration Services in the SQL Server 2005 release, Microsoft finally possessed a tool that could perform ETL (Extraction, Transformation & Loading) tasks. The predecessor of SQL Server Integration Services, DTS – Data Transformation Services, already had the capability to Extract and Load data coming from several environments, but was lacking the often quite important "transform" functionality.