Integrations Services is a robust environment capable of easily moving large quantities of data efficiently. Its ETL-specific tools provide a framework where the developer can focus on applying business logic rather than such repeatable features such as manually mapping data with scripts. Moreover, the dataflow provides the ability to transform data in memory with Data Flow Transformations, giving SSIS packages major performance benefits over comparable transformations performed with Transact-SQL. Those features, with its built- in error handling and logging, and with the exciting makeover that SSIS received with the SQL Server 2012 release, make SSIS one of the most useful tools in the realm of SQL Server. If you happen to be a reluctant adopter of SSIS, give it one more try. A little bit of effort learning this great tool goes a long way toward improving the lives of most developers.

Get Microsoft SQL Server 2012 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.