Every new version of SQL Server and its components, including SSIS, present a significant number of changes. The number of improvements in SSIS 2012 is too big to even be listed in this book. Therefore, the following list only mentions the most significant among these:
In this release, SSIS has new features related to the integration with external data sources. Among them, integration with Hadoop is probably the most interesting one. Hadoop is an open source Apache project with a distributed filesystem. SSIS supports data transfer between SQL Server databases and the Hadoop filesystem, and it also can transfer data between Hadoop and other data sources.
SSIS 2012 has introduced the project deployment model. In this model, parameters are used to assign values to package properties, and they create a project together with the packages. A project is deployed to the SSISDB catalog on an instance of SQL Server. One can validate projects and packages before execution. Package...