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

An “secret” SSIS XML Destination Provider you might not found yet

  (Sample code included at the end of the post) The initiator for this post was Dan Atkins who wanted to create a feed from relational data to consume it directly from a created gadget. Where can I find that in the toolbox ? First of all, you won’t a XML destination adapter as of…

22

SSIS as a data source needed ? Watch out for configuration traps

  Someone pinged me according the article I wrote about SSIS as a data source in Reporting Services. In general this is easy to implement and configure. One problem though occurs if you already had SQL Server 2005 on the machine first and updated to SQL Server 2008. You will receive the following error: The…

1

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

 (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) (Sample project attached to the blog entry !)  Having stated the need for getting data from SSIS packages in Reporting Service in my last post (Part 1), we now want…

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