Monthly Archives: November 2013

Reverse or Mirrored Bar Chart in SSRS

Posted on November 25, 2013 by MikeDavisSQL

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

Posted on November 18, 2013 by MikeDavisSQL

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

Posted on November 11, 2013 by MikeDavisSQL

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

Posted on November 4, 2013 by MikeDavisSQL

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