We have started discussion on SQL Server 2012 last month
Following are link if we have missed any click on any link for info on my blog !
- MSBI #70 – Developer Experience #1 – What’s new in SSIS ! No More NEW from Now !!
- MSBI # 69 – Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012
- MSBI # 68 – SSIS # 28 – SQL Server 2012 – New Features , SSDT Introduction and links
- MSBI # 67 – BI# 5 – SQL Server 2012 – Installation, Problem, Support and Help !
- On my Developer Experience is series in which are going to stay focus on overview of SQL server 2012 and we have following topics/post in series – Developer Experience
- Developer Experience #1 – What’s new in SSIS
- Developer Experience #1.5 –Design Flexibility in Development SSIS (This post)
- Developer Experience #2 – look & Feel and Visual Improvements
- Developer Experience #3 – Accessibility Changes Custom SSIS Toolbox
- Developer Experience #4 – Connection Manager , Variables and Parameter
- Developer Experience #5 – Scripting and Expression Improvements
- Developer Experience #6 – Data Flow Designer Improvements
I just surprised and thought of posting it sooner about this lots of but not listed and observed and very highly useful features in SSIS 2012 in SSDT.
In this article we are going to cover following exciting and so developer friendly parameter of SQL Server 2012
- Easy Grouping of task Quickly
- Connection of Task not required hold of pointer
- Very fast User Interface operation Open and Close with fade effect
- Fast Auto size option on just Right Click
- More clear view with package explore
- Two Parameter option i.e. Package and Project
- Distinct separation of Parameter and Variable
Easy Grouping of task Quickly
Just select and by using pointer task where you have to apply group.
As shown in following print screens we can select several task
Once selected task are Highlighted we can group it easily .
But one more character we can Undo and Redo at any time if we select wrong task
Connection of Task not required hold of pointer
Wav !! This is amazing so from now there is no headache for pointer very long and selecting task .
Just select once and go to desired task where we have to apply connection, remember your connection will follow you .
Very fast User Interface operation Open and Close with fade effect
In Connection task , I mistakenly click on precedence constrain editor , And when i cancelled same i saw fade and fast effect of that prompt screen .
Fast Auto size option on just Right Click
We don’t have click Tools and then Diagram just select Task and Click on Auto size it will make every alignment for you in proper manner.
More clear view with package explore
We can see package explore as separate TAB and moreover more informative
Two Parameter option i.e. Package and Project
In SSDT we can have two type of variable declaration
- Package - For particular package
- Project – For entire project
Distinct Separation of Parameter and Variable
We can see separate existence of both type of variable .
Hope you will like this post for New Features on SSDT and ready to use.
If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.
If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :
For More information related to BI World visit my Mentalist Blog
Link Resource Blog >> Daily Interesting links
SQL Server Mentalist >> SQL Learning Blog
Business Intelligence Mentalist >> BI World
Connect With me on
2 thoughts on “MSBI #73 – SSIS #31 – SQL Server 2012 – Developer Experience #1.5 –Design Flexibility in Development”