Home > BI Hot, BISeries, Live!, SQL Serever 2012, SSAS, SSIS, SSRS > MSBI # 68 – SSIS # 28 – SQL Server 2012 – New Features , SSDT Introduction and links

MSBI # 68 – SSIS # 28 – SQL Server 2012 – New Features , SSDT Introduction and links

Hi Folks,

Now lets get started and acquire more knowledge towards ocean of  SQL server 2012.

I have explained installation and few features in following blogs

    SQL Server 2012 is really superb and introduces new features and enhancements that increase the power and productivity of developers, administrators, and knowledge workers who develop data transformation solutions.

In this blog we are covering points points

  • Important future and links for SQL Server 2012
  • What is SSDT ? and what does it represent ! Less Prompts in SQL Server 2012
  • How to create new Solution in SSIS inn SSDT
  • Information Tab in SSDT
  • New Zoom In option
  • Undo and Redo Task enhancement in SSDT
  • Undo and Redo Task
  • Connection Manger
  • Overview of all features

Important future and links for SQL Server 2012

Following are most important and new features and enhancements by area and respective link .

    What is SSDT ? and what is represent !
    First most important noticed and interesting change we have SSDT – SQL Server Data Tools

image

    SSDT is nothing but BIDS !!
    Less Prompts
    Second change i have noticed is when we change package name its not ask that prompt Open-mouthed smile

image

How to create new Solution in SSIS inn SSDT

Lets create new SSIS Solution in SSDT

image

It has really high and reach resolution like visual studio

image

Information Tab in SSDT  

SSIS – SSDT Shows useful information tab

image

For example see how this tab can be useful

image

New Zoom option

We have Zoom In option in SSDT which is rally nice to have feature

image

Undo and Redo Task

We have undo and redo option now SSDT which is really want feature and really useful too

image

Designer Enhancement

Task are really more beautiful and curved in corners

image

Connection Manger

Also we have connection mangers defined in solution windows itself

image

To move an item to a category

image

· Right-click an item in the toolbox, and then click one of the following:

  • Move to Favourites
  • Move to Common
  • Move to Other Sources
  • Move to Other Transforms
  • Move to Other Destinations
  • Move to Other Tasks

Click the toolbox button that is located in the top-right corner of the package design surface

    imageOn the View menu, click Other Windows, and then click SSIS Toolbox
    Overview of all features

Following are also SQL Server 2012 Components as before we have in 2008 R2

  1. SQL Server Data Tools
  2. SQL Server Management Studio
  3. Analysis Services
  4. Configuration Tools
  5. Data Quality Services
  6. Documentation & Community
  7. Integration Services
  8. Master Data Services
  9. Performance Tools
    SQL Server 2012 we have below four new components available.
  1. SQL Server Data Tools
  2. Data Quality Services
  3. Documentation & Community
  4. Master Data Services

link resource for more information ‘

    Hope you will like this post for New Features , SSDT Introduction and links on SQL server 2012.

    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 :

Link Resource Website

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

| FaceBook |Twitter | linkedIn| Google+ | WordPress | RSS |

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,169 other followers

%d bloggers like this: