Setting things in the right compatibility view (Visual Studio 2005 / 2008 / 2010 / 2012 / 2013 / BIDS / BI Development SSAS SSIS SSRS SSDT, SQL Server 2005 / 2008 / 2008R2 / 2012 / 2014)

  A very common request and question is (as I have to confess that this is confusing) is which version of SQL Server (SSMS – SQL Server Management Studio, BIDS – Business Intelligence Development Studio, VS- Visual Studio) does works together with which version of SQL Sever which target version and which project type. Here…

2

Finally, the family…united. SQL Server BI Project templates now available in Visual Studio 2012

  Update( 30.06.2014): Beside the below mentioned information, I have written an updated compatibility sheet for the avaialable combinations or Visual Studio / SQL Server and the BI templates which is published here. We waited and hoped and now we finally have them. SQL Server BI project templates in Visual Studio 2012. This includes Project…

16

SSIS as a data source for SSRS–where is it gone for SQL Server 2008 R2

Some time ago I did a blog entry for SQL Server Integration Services packages as a data source for SQL Server Reporting Services reports. You can find this article here. This feature relies on a data processing extension that is explained in detail here (http://msdn.microsoft.com/en-us/library/ms345250.aspx). Due to security reasons, this feature has been deprecated and…

4

Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 1

 (Update: Due to security reasons the functionality retrieving data from SSIS packages has been deprecated and is no longer available in  SQL Server 2008 R2) There are several scenarios where you want to extract data from different data sources and combine them within a report. Unfortunately if you have structure like a Table or Tablix,…

2