The Row Count transformation is a pretty straightforward transformation. It does the following two things: 1. It counts rows as data passes through a data flow, and...

The Row Count transformation is a pretty straightforward transformation. It does the following two things: 1. It counts rows as data passes through a data flow, and 2. it stores the final count in a variable. (Note that the vari...

A few months ago, I had a post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube. If you have worked on creating SSRS reports accessing cubes for a little while, you already knew that my post really doesn’t hel...

A few months ago, I had a post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube. If you have worked on creating SSRS reports accessing cubes for a little while, you already knew that my post really doesn’t help you much in...

When I wrote the blog SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package, it was purely “inspired” by an ETL design I was working on during the day, and also an SSIS training piece I was reading from Pragmatic Works....

When I wrote the blog SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package, it was purely “inspired” by an ETL design I was working on during the day, and also an SSIS training piece I was reading from Pragmatic Works. ...

Sherry, SSRS question: I am plotting data for 2 companies on a single XY axis. This is a line chart: X is the month, Y is the sale amount. However, sales don't happen every month, causing breaks in the lines. How can I get rid of those? They don't...

I've created a report hosted on SQL Server Reporting Services 2005. I know how to use the Reporting Services Web Services Class Library to create a timed subscription, so that a user can receive the report automatically every day. Now I need to exte...

I hope so far you are convinced that you need to learn at least one ETL tool in order to stay competitive in the SQL/BI profession. I also hope that Microsoft SSIS is your choice....

I hope so far you are convinced that you need to learn at least one ETL tool in order to stay competitive in the SQL/BI profession. I also hope that Microsoft SSIS is your choice. I’ve worked with two types of people with ve...