Helpful information and examples on how to use SQL Server Integration Services.
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:
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
Why is everything monochrome? Are we all expected to be color blind?
Finally the BI tooling aligned! Indeed happy developing! Thank you for the wonderful and fast advancements in the user experience!
(Could you please share some licensing details as well?)
Thanks! Will try it soon... looks indeed a little grey...
In the Dark theme, the button "View Report" in the report view is grey on grey background with white color - impossible to see.
I get mixed architecture failure. Friend of mine also got this. Even though it says both are supported?
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?
Only available installation bits are x86-32, not x86-64 and it can't be used by us with 64-bit installations. Please fix.
New instance option worked. Works fine now.
this is great.
I just installed it.
do we have to purchase licensing for this?
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.
Robert Bosch GmbH
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.
I can only find an x86 version of SSDT BI so when trying to install on the server we get
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