Tuesday, August 30, 2011

What’s new in Denali CTP3? -- SSIS

1. All Tasks and Transformations are with new look and feel (round corners)

2. Now we can use UNDO if we delete the control object.

3. Toolbox comes now empty
To get the list of all tool box items need to click on right top side

4. Magical Zoom In/Out Scale added

5. New Look and Feel of the Tool Box (Divided on Category base)

6. New Tab added for Parameters

7. New Tab window added (Getting Started) for online learning.

8. Name is coming with * (star) means it is modified but not saved.

9. Scope of variable is package level (By default now) and we can change it any time now.
Now want to change the scope so select the variable and click second button next to create variable to move the varible from Package level to Item level like this.

10. Few new Tasks added e.g. Expression Task

11. Addition of DataViewer is simple and we can disable as well.

12. Development in VS2010

13. Even deleting flow lines (in disconnected mode) we can open the following transformations.

14. After changing in the source (Table Field or Table name changed) we can map the fields by clicking on the first flow line instead of opening each and every control/Transformation.
After setting (mapping) in the Resolve References options rest all the transformation with update automatically.

15. New group feature added in Data Flow table as well (if we want to keep all/some of the transformations in one group now we can do). It is somehow similar to container but now possible in Dataflow Tab.

16. Shared DataSource Connection: If we create Shared datasource it automatically comes (appears) in every package (by default). Note: We cannot do undo once the connection created/deleted.

17. While executing and after completion the package execution now the symbol changes.

18. Work Offline Connection Manager:

Now we can set connection manager as offline but this will be activate till the package is open. Once the package closed and reopen then connection will turn on automatically.
Many more properties also added like Convert to Project Connection and Test Connectivity.

19. We can maintain up to 10 version of the SSIS package now.
a. Once the package is deployed in SSISDB under integration Services folder then we can maintain the package version up to 10 versions. If we want we can change the version nos.
b. Not only version but we can modify the connection manager, variable default values and 32 bit compatibility and move the package.
c. We can run the reports as well on top of our packages

20. Package Reference (scope) and Package variable scope enhanced.

Some Video URLS:

1. http://www.youtube.com/watch?v=JF_LjLy32j8&feature=related (Introduction to SSIS)
2. http://www.youtube.com/watch?v=5rUyQdCeYx4(Variable scope, Expression task)
3. http://www.youtube.com/watch?v=5N0Ub77ss0g&feature=related(What's New in SSIS Denali)
4. http://www.youtube.com/watch?v=5N0Ub77ss0g (SSIS Training)
5. http://www.youtube.com/watch?v=sD-gX3ixKAg&feature=related (3 new features in Denali)
6. http://www.youtube.com/watch?NR=1&v=UX2pfGoTDHc (Create SSISDB -I)
7. http://www.youtube.com/watch?v=UPTI4-94O_I&feature=related(Create SSISDB -II)
8. http://www.youtube.com/watch?v=vZa3-dx8WV8&feature=related (SSIS Version maintenance)
9. http://www.youtube.com/watch?v=kw8k8effv5U&feature=related(Working with Integration Services projects)