|
|
-
|
|
I had many posts that share my experiences with using package configuration files to make my SSIS packages portable from my local development BIDS environment, to the test environment, and the production environment.
In the next few blogs, I’ll share with you a few simple steps to create your......
|
|
-
|
|
A reader asked me how to add grand totals a matrix (A Sample of Matrix in SSRS).
It’s actually pretty easy to accomplish that in both SSRS 2005 and 2008. I am going to show a few screen shots here.
Challenge
Suppose you have a very simple table with sales data for products sold from each st......
|
|
-
|
|
In my previous blog, SSRS & SSAS #63 – Stop SSRS 2008 MDX Query Designer from Overwriting Parameter Queries, I mentioned that you can manually remove the parameter default values in BIDS before you deploy your reports to your report server.
But what if you already “infected” y......
|
|
-
|
|
In a previous blog, SSRS & SSAS #61 – SSRS and SSAS Integration: how bad it is and
our hope with two types of data providers, I complained about how bad the integration
between Reporting Services and Analysis Services is.
Complain itself will not solve any issue. But......
|
|
-
|
|
The team I recently moved into had never had a data source created on their report server for an Analysis Services source.
A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data Source Type.
For credentials for connection, we correctly flagged &ldqu......
|
|
-
|
|
I am a SQL purist, meaning that I have vowed never to use cursors in T-SQL to loop
through rows record by record.
In SSIS package design, however, I have used the Foreach Loop Container very
often. I would not say that I have broken my vows though for the following reasons:
......
|
|
-
|
|
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 variable is only populated
when the data flow ......
|
|
-
|
|
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 terms of solving real problems in your work.
......
|
|
-
|
|
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.
However, I was pleasantly surprised by some com......
|
|
-
|
|
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 very different views on ETL tools.
One is ......
|
|