SSIS – Package design pattern for loading a data warehouse
I recently had a chat with some BI developers about the design patterns they’re using in SSIS when building an
SSIS – Blowing-out the grain of your fact table
Recently I had to create a fact table with a lower grain than the source database. My source database contained
SSIS – Let the Excel connection manager pick the right column data types from an Excel source
The excel connection manager scans every first 8 rows to determine the data type for a column in your SSIS
SSIS – Unpack a ZIP file with the Script Task
A while ago I needed to unpack a couple of zip files from SSIS. There is no Microsoft SSIS task
SSIS – Lookup is case sensitive
A while ago I figured out that the lookup transformation is case sensitive. I used a lookup to find dimension
SSAS – Clear SSAS cache with an SSIS package
Often I see developers on different forums asking how they can clear the SSAS cache. You can achieve this by
SSAS – Speed up dimensions using a NULL default cube measure
Recently I faced some problems with the performance of SSAS dimensions. The cube users were using a large dimension with
Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file
A lot of developers have SQL Server and its different services running on their PC or notebook to develop or
SSIS – Decrease your fact table loading time up to 40%
Replace the multiple “Lookup Error Output” Derived Columns and Union All’s with a single Derived Column and get a performance
MCTS – I passed the 70-556 “Microsoft Office PerformancePoint Server 2007” exam!
My last blog is from a few months ago because I have been quite busy lately. Fortunately I have quite
Jorg Klein's Blog 