Getting started with SSDT – SQL Server Data Tools

Posted on by

If you are looking for BIDS (Business Intelligence Development Studio) in SQL Server 2012, then you will not find it. It is replaced with SQL Server Data Tools (SSDT) in SQL Server 2012. In this blog we shall take a sneak peek at how to open SSDT and create a new project.

Go to start -> Microsoft SQL Server 2012 (in this case it is RC0), but in final release, it will not be there, so I mentioned the general term.  If you have chosen to to Install SSDT while installing SQL Server 2012 on the machine, you should see SQL Server Data Tools as shown below. Click to open SSDT.

When you are using SSDT for the first time, this screen is displayed, where you are requested to choose which Environment settings would you be using. Select Business Intelligence Settings as shown below and click, Start Visual Studio.

In order to create a new Project click on New Project as shown below.

Then, a new Project dialog box appears where you can select what kind of Project that you would like to create. Once you have selected the type of project, you can enter the name of the project and click OK to start creating your choice of project.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

— Bru Medishetty

8 thoughts on “Getting started with SSDT – SQL Server Data Tools”

  5. Hello, I am encountering a bit of an issue and would like to know if you can help me out from the goodness of your heart. I have installed SQL SERVER 2012 RC0, SSDT is installed, but when I attempt to create a SSIS package I get the following error: “Microsoft Visual Studio is unable to load this document. To design Integration Services packages in SQL Server Data Tools (SSDT). SSDT must be installed by one of SQL SERVER 2012 RC0 editions: Standard, Enterprise, Developer, and Evaluation. To install SSDT, run SQL Server setup and select SQL Server Data Tools.” My question to you is how can the software be installed, opens but not recognize that it is installed? Are you aware of any issue such as this?

  6. Hi,

    Seems to be surprising..as It clearly shows you are in SSDT. I don’t have an idea why that message seems to appear..

    When you launched SSDT, in the step choose Choose your default environment settings(pic is in the blog), what did you choose? Did you choose Business Intelligence Settings..?

  7. I also receive the same error message “Microsoft Visual Studio is unable to load this document. To design Integration Services packages in SQL Server Data Tools (SSDT). SSDT must be installed by one of SQL SERVER 2012 RC0 editions: Standard, Enterprise, Developer, and Evaluation. To install SSDT, run SQL Server setup and select SQL Server Data Tools”. I have selected the default settings as “Business Intelligence”, still facing the same issue.. tried different ways to resolve but nothing works out.

Leave a Reply