Monthly Archives: November 2013

Reverse or Mirrored Bar Chart in SSRS

There are some pretty charts out there and most of them can be done in Reporting Services. There is one type of chart I had someone ask for that is not natively built in to SSRS. But with a little … Continue reading

Posted in SSRS, Syndication | Tagged | Leave a comment

SSIS Execute SQL error – No disconnected record set is available

If you get the error in SSIS that says: …failed with the following error: “No disconnected record set is available for the specified SQL statement.”. Possible failure reasons: Problems with the query, “ResultSet” property not set correctly, parameters not set … Continue reading

Posted in SSIS, Syndication | Tagged | Leave a comment

SSRS Map Layers Parameter

With the new Map control in SSRS 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If you want to allow your users to change the map type you would think you could map a parameter to … Continue reading

Posted in SSRS, Syndication | Tagged | 1 Comment

SSAS – Process everything

This is just  short blog with a quick tip for those that don’t know. When working with SSAS it is sometimes necessary to process every dimension before continuing with development. This can be accomplished with a couple of clicks on … Continue reading

Posted in SSAS | Tagged | Leave a comment