Monday, November 15, 2010

SSIS New Features...

With the PASS Summit winding down, there is a lot activity in the SQL Server blog sphere about the next SQL Server Release, SQL Server 2011 (Code Name: Denali). One of the areas of improvements which I have been following is the New Features in SSIS. There have been lot of wish lists request, one of the video's/demo which explain these very well is available at the following link: The content in this video is presented by Steve Swartz.
The features are broken down into the following areas: User Interface/Designer Experience, Project Management (This explains features which enhance multiple package experience) and Administration.
In The Designer improvements some features explained are Undo and Redo, a new improved mapping editor. This allows one to export and import mappings, this is huge since now it allows the developers to store mapping s outside the SSIS packages. There is also an Zoom in/Zoom out feature which comes in handy while developing complex packages. As part of the Project management, there is a feature called Parameters being added to SSIS packages, communication betwen child and parent packages would improve with this feature.
As part of the Administration piece, a new SSIS server is being built out, this could be installed in the SQL Server instance. This SSIS Server is being built out with the DBA in mind, giving ability to monitor these packages in a more productive manner. In the Adminstration side, the deployment process has become more streamlined and allows one to set parameters and variables by pointing to differen environments. There is going to be a SSMS based SSIS package management feature and dependency analysis.

No comments:

Post a Comment