1.Data Taps
Data taps are a new feature in SQL Server 2012 for troubleshooting package execution. You can capture a copy of the data from a specific data path in your data flow tasks in a comma-delimited file at run time.Much like data viewers in design time.Data taps enable you to analyze data in a production environment.For more info
2.New Shared Connection Managers
In prior versions of SSIS, connection managers were scoped to individual packages, not projects. An SSIS project did not allow shared connections across packages inside the project.
This release allows you to create connection managers at the project level that can shared by multiple packages in the project. The connection manager you create at the project level is automatically visible in the Connection Managers tab of the SSIS Designer window for all packages.
3.SSIS Parameters at the Project, Package, and Task Level
Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package level.
4.UNDO Feature.
In SQL Server Integration services 2012, you can undo and redo up to 20 actions in the SSIS Designer.Undo and redo is not possible in prior versions of SSIS.
5.Support for ODBC Data Sources and Destinations.
This is a new component in SSIS 2012.This connects to a defined ODBC source/destination by using native ODBC.In previous versions we use OdbcDataProvider in ADO.NET.
6.New Deployment Feature
Project Deployment model is the new deployment model in SSIS 2012.Which uses its own designated database called SSISDB.In package deployment model a package is the single unit but in project deployment model deploy the whole project to the SSIS catalog,
7.New Management Dashboard Feature
This report shows activity on the package execution.
Data taps are a new feature in SQL Server 2012 for troubleshooting package execution. You can capture a copy of the data from a specific data path in your data flow tasks in a comma-delimited file at run time.Much like data viewers in design time.Data taps enable you to analyze data in a production environment.For more info
2.New Shared Connection Managers
In prior versions of SSIS, connection managers were scoped to individual packages, not projects. An SSIS project did not allow shared connections across packages inside the project.
This release allows you to create connection managers at the project level that can shared by multiple packages in the project. The connection manager you create at the project level is automatically visible in the Connection Managers tab of the SSIS Designer window for all packages.
3.SSIS Parameters at the Project, Package, and Task Level
Integration Services (SSIS) parameters allow you to assign values to properties within packages at the time of package execution. You can create project parameters at the project level and package parameters at the package level.
4.UNDO Feature.
In SQL Server Integration services 2012, you can undo and redo up to 20 actions in the SSIS Designer.Undo and redo is not possible in prior versions of SSIS.
5.Support for ODBC Data Sources and Destinations.
This is a new component in SSIS 2012.This connects to a defined ODBC source/destination by using native ODBC.In previous versions we use OdbcDataProvider in ADO.NET.
6.New Deployment Feature
Project Deployment model is the new deployment model in SSIS 2012.Which uses its own designated database called SSISDB.In package deployment model a package is the single unit but in project deployment model deploy the whole project to the SSIS catalog,
7.New Management Dashboard Feature
This report shows activity on the package execution.
No comments:
Post a Comment