Monthly Archives: October 2013

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

SSRS Nulls in a matrix

Posted on October 21, 2013 by MikeDavisSQL

In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the … Continue reading →

Posted in SSRS | Tagged | Leave a comment

Missing Foreign Keys in SSAS DSV

Posted on October 14, 2013 by MikeDavisSQL

When creating report models you might run into bad database designs where the tables have no foreign keys and/or no primary keys. This can be resolved in the report model DSV. I have created two tables, one with first names, … Continue reading →

Posted in SSAS | 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