SQL Server Integration Services 2012 – Project Deployment Model
IntroductionSQL Server Integration Services (SSIS) is the popular ETL (Extraction, Transformation & Loading) solution of the Microsoft BI Suite. With the introduction of SQL Server 2005, Microsoft completely reshaped the way data loads could be designed in SQL Server. Where previous releases used Data Transformation Services (DTS), which mainly could only perform Extract and Load tasks, Integration Services offered full Extract, Transform and Loading functionality.