|
|
-
|
|
In SSIS Denali 2012, toolbox has been enhanced to provide better experience to users. 2 New categories been added to both control flow toolbox and dataflow toolbox and items has been categorized according to their use.
1. Favorites
2. Common
Show the ...
|
|
-
|
|
Catalog DB is the new feature in SSIS 2012, which is point of administration and deployment for project, packages, environments and parameters etc. After the project is created, when it is deployed, it will be deployed to Catalog DB along with all packa...
|
|
-
|
|
Before SQL Server 2012, to pass parameters to packages, configurations have been used. You can create Configurations with key/value pairs and you can pass those as parameters to packages.
In SQL server 2012, code named “Denali” SSIS, a new feature “Pa...
|
|
-
|
|
This is very big change in SSIS Denali. Now SSIS Denali has a new deployment model, “Project Deployment Model” along with traditional “Legacy Deployment Model”. All the new projects in SSIS Denali in default will use this new “Project Deployment Model”....
|
|
-
|
|
Before denali, while choosing source and destination for data flow task, user has to choose among the list of source types from the toolbox, which will be little confusing for beginners. To enhance the experience for beginners, in SSIS Denali, Data Flow...
|
|
-
|
|
In SSIS 2012, If your package is too big, you can group the items, which makes package readable. Select the items you want and right click and choose “Group”, which will create a border surrounding selected items.
You can see in below diagram with the...
|
|
-
|
|
One thing that annoys users in SSIS before 2012 is lack of support of Undo and Redo. Once you performed an operation, you can’t undo that. Now in SSIS 2012, we can see the support of undo/redo.
![alt text][1]
[1]: http://beyondrelational.com/images...
|
|
-
|
|
Until SSIS 2012, in annotations, to enter multi-line text, user has to do it in text-editors or by pressing Ctrl+Enter. Now in SSIS 2012, annotations support entering multi-line text. By just pressing enter key, we can insert text in next line.
![alt ...
|
|
-
|
|
In few scenarios, our packages might contain a lot of items, which makes very difficult to understand those. Now in Denali, you can group these items, which gives better look and feel, and a new user can simply understand, what’s happening inside the pa...
|
|
-
|
|
SSIS Denali 2012 has new design surface with a slicker look and feel, which has some enhancements .
**Zoom:**
We can zoom in/out by dragging the slider which will be in right side corner of the design surface. Alternatively we can right click on desi...
|
|