SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online


Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading or downgrading – it just works.

The download/install is named to ensure you get the SSDT templates that contain the Business Intelligence projects. The setup for these tools is now available from the web and can be downloaded in multiple languages right here: http://www.microsoft.com/download/details.aspx?id=36843

The setup includes:

  • Visual Studio 2012 integrated shell (if you don’t have Visual Studio 2012 on your machine)
  • Project templates for
    • Analysis services projects
    • Reporting services projects
    • Integration services projects

 It will be installed as a new shared feature for SQL Server 2012 and can be uninstalled from there.

This download contains the same features as SQL Server 2012 SP1 and supports the themes introduced for Visual Studio 2012.

Some screenshots of the templates in Visual Studio 2012:

 

New project in Visual Studio 2012 black theme

Integration services project in Visual Studio 2012 dark theme

 

Multi-dimensional project in Visual Studio 2012 light theme

Tabular model project in Visual Studio 2012 dark theme

 

Reporting services project in Visual Studio 2012 light theme

 

Happy developing!

 

 

 

 

 

 

 

 

Comments (22)

  1. Loyal Microsoft Developer says:

    Why is everything monochrome? Are we all expected to be color blind?

  2. ArthurZ says:

    Finally the BI tooling aligned! Indeed happy developing! Thank you for the wonderful and fast advancements in the user experience!

  3. Thanks!

    (Could you please share some licensing details as well?)

  4. Thanks! Will try it soon… looks indeed a little grey…

  5. Andrei says:

    In the Dark theme, the button "View Report" in the report view is grey on grey background with white color – impossible to see.

  6. Mikael says:

    I get mixed architecture failure. Friend of mine also got this. Even though it says both are supported?

  7. Jimmy says:

    Remember to “Perform a new installation of SQL Server 2012″ and not “Add features to an existing instance of SQL Server 2012″ or you will get a “same architecture installation” failed message.

    I got error when building BI projects via devenv.exe command line. Does anyone else have similar issue?

  8. Only available installation bits are x86-32, not x86-64 and it can't be used by us with 64-bit installations. Please fix.

  9. New instance option worked. Works fine now.

  10. Mirana says:

    this is great.

    I just installed it.

    do we have to purchase licensing for this?

  11. Hansjoerg Reister says:

    Hello,

    thanks for adding VS 2012 integration. the biggtest advantange is that I now have it in the same TFS workspace.

    But regarding fixing of the known issues i'm disappointed. There are some bad errors that still exist after the port. Overall the ssis data workflow editor is not really working well.

    – It still sometimes looses meta-data forcing to delete and add a worflow component (with a big chance to introduced a bug, e.g. forgetting to set an outer join option for a merg).

    – Adding new columns to a data source still doesn't propagate the downstream thru sort, merg join and union all.

    – The issue that components move 1 kilometer across the screen if you grab them in the wrong way still exists.

    – A new bug is that when editing sometimes components get deleted randomly if you try to move them around with the mouse.

    I tried the SSIS Data Flow editor in VS 2012. But returned to VS 2010 where it is also not working really well. The overall concept of SSIS is great and the other management utilities are working really great. Only this editor needs some polishing.

    Regards

    Hansjörg Reister

    Robert Bosch GmbH

    Germany

  12. Reinaldo says:

    Same issue as Jimmy.

    —————————

    Rule Check Result

    —————————

    Rule "Same architecture installation" failed.

    The CPU architecture of installing feature(s) is different than the instance specified. To continue, add features to this instance with the same architecture.

    —————————

    OK  

    —————————

  13. Rei says:

    I can only find an x86 version of SSDT BI so when trying to install on the server we get

    —————————

    Rule Check Result

    —————————

    Rule "Same architecture installation" failed.

    The CPU architecture of installing feature(s) is different than the instance specified. To continue, add features to this instance with the same architecture.

    —————————

    OK  

    —————————

  14. Sam says:

    Now that the updates donot happen to SSDT BI in Visual Studio 2010 we are forced to use Visual Studio 2012 but without colors we cannot differentiate SSIS Tasks and components , Please add colors back

  15. Jogai says:

    Can we deploy to ssrs 2008 with these tools?

  16. Steak says:

    Hey,

    Nice tool, resolved some anoying bug from vs2010.. but do you really work with it ? Come on, how are we supposed to work with monochrome things ?

    It is very difficult to distinguish objects, more difficult to see enabled/disabled task…

    This interface is a pain to work with…

    Please add color back to icons and objects….

  17. Karthi says:

    Hi

    I have Visual studio 2013 and need to work with SQL server 2012.. However when I installed SSIS Data tools 2010 vesion in this PC the Integration projects is not showing up as option. What do I need to do now ? Is there a SSIS Data tools for Visual Studio 2013 ?

    SOS

  18. Unable to uninstall SSDTBI says:

    @Jimmy. i followed your instruction "“Add features to an existing instance of SQL Server 2012″ instead of a Instance.

    After then, I can not uninstall it. Because it doesn't have an Instance name.

  19. Anonymous says:

    We currently utilize TFS here but the SSRS report project was written source controlled under VSS. I removed the bindings, converted the solution to VS2012, and installed SQL Server Data Tools for VS2012 but still cannot select a source control plugin. Will this down load remedy that? Why so many hoops from MS to get anything done? Thanks

  20. Anonymous says:

    It seems every client must have at least a developer version of SQL Server 2012 installed, even if SQL Server is not used locally, e.g. in the case of all developers using a development server.  Could someone from Microsoft please just confirm that this is the case and put it on the main SSDT – BI page so that we're all clear.

  21. Jose says:

    The install say this error when i double click the installer: An error was encountered

                                                Error no especificado