Category Archives: Syndication

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

SSIS Pivot on bad data

Posted on October 28, 2013 by MikeDavisSQL

The pivot transform in SSIS is already a pain to use. When you have bad data it makes it even worse. In this blog I am going to show how to handle bad data when using the pivot transform. You … Continue reading →

Posted in SSIS, Syndication | Tagged | Leave a comment

SSIS Records on the Same Row – kind of like pivot

Posted on October 7, 2013 by MikeDavisSQL

If you have two or more records on the same row, and need to write each record on its own row in a destination, you have two choices. You can do this in series or parallel in a single data … Continue reading →

Posted in SSIS, Syndication | Tagged | 1 Comment

MDX YTD Calculation Issus

Posted on September 30, 2013 by MikeDavisSQL

If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008. My first thought … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | Leave a comment

MDX Scope with an If Then statement

Posted on September 23, 2013 by MikeDavisSQL

The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a subcube. Dustin Ryan wrote a great article on the scope statement here. The issue I am going to cover will … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | 2 Comments

Loop Through Excel Files in SSIS

Posted on September 16, 2013 by MikeDavisSQL

You can loop through excel files using SSIS. This will use the For Each Loop container and a data flow task. First Create a variable named strExcelfile as a string variable; you can leave the value blank. Next, drag in … Continue reading →

Posted in SSIS, Syndication | Tagged | 17 Comments

Junk Dimensions with no Loading Needed

Posted on September 9, 2013 by MikeDavisSQL

When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be in any other dimension. When this occurs you can combine them into one dimension call a Junk Dimension. In this … Continue reading →

Posted in Dim Model, SSAS, Syndication | Tagged | Leave a comment

Handling Large Many to Many bridge tables

Posted on September 2, 2013 by MikeDavisSQL

In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of the problems that arise from many to many bridge tables are the size of these tables. In this example we … Continue reading →

Posted in SSAS, SSIS, Syndication | Tagged , | 1 Comment

Execute SSIS Packages with a Macro in BIDS

Posted on August 19, 2013 by MikeDavisSQL

When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS to run a package. One problem that can occur when using this button is the deployment of project and the … Continue reading →

Posted in SSIS, Syndication | Tagged | 1 Comment