New & More Organized Toolbox for SSIS in BIDS in Denali CTP1 – Usability Enhancements in BIDS-SSIS in SQL Server code-named Denali – Part 2
As part of the various usability enhancements introduced in SQL Server code-named Denali CTP1, a Dedicate Toolbox called SSIS Toolbox has been introduced in SQL Server Business Intelligence Development Studio (BIDS) for SQL Server Integration Services (SSIS) Packages.
This is a dedicated toolbox for SSIS and does not contain any usable components when viewed in an SSAS or SSRS Project. Below is a screenshot of the new and dedicated SSISToolbox in BIDS in Denali.
The new SSISToolbox is more organized compared to the Toolbox available in the current version of SQL Server Integration Services (Current Version of SQL Server is SQL Server 2008 R2 at the time of writing this article). Both the Tasks in Control Flow and Sources/Destinations/Transformations in Data Flow have been grouped into more meaningful groups based on the type of functionality performed by the Task/Transformation as shown in the below screenshots.
Control Flow Groups/Items in Toolbox in SSIS (SQL Server 2008 R2)
Control Flow Groups/Items in SSIS Toolbox in SSIS (SQL Server code-named Denali)
Data Flow Groups/Items in Toolbox in SSIS (SQL Server 2008 R2)
Data Flow Groups/Items in SSIS Toolbox in SSIS (SQL Server code-named Denali)
Here are some of the key highlights of this new SSIS Toolbox in CTP1 release of Denali SSIS:
- New Groups/Folders cannot be added to SSIS Toolbox neither at Control Flow level nor at the Data Flow Level.
- Tasks/Transformations can be moved between Groups/Folders within SSIS Toolbox in a logical/meaningful manner. Example: Copy Column Tranformation can be moved from Other Transforms to Favourites or Common folder but cannot be moved to Other Sources or Other Destinations folder since Copy Column is a Transformation and not a Source/Destination.
Here are the other usability enhancements in SSIS in Denali CTP1 release about which I have blogged previously: