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

Getting relational data as well formed XML structures out of SQL Server

  I saw many times people having problems working with XML structures in SQL Server. It is that easy, even more with the new functionality in SQL Server 2005>. Most times people try to take the XML line with the least resistance and effort which would be XML AUTO. While XML AUTO is easy an…

1