In SQL Server 2012, Microsoft has further extended the capabilities of SSIS into a much more comprehensive and robust data integration platform—with the emphasis on the word platform. The following are some of the highlights of SSIS 2012:
A new deployment model for deploying projects to the Integration Services server.
The ability to use server environments to specify runtime values for packages contained in a project.
New views, stored procedures, and stored functions to help in troubleshooting performance and ...