Davy's Blog

I recently struggled with the following challenge in Analysis Services:
In one of the fact tables there was a field duration which actually was a duration of a certain status in seconds. I needed to display this in a readable format, like “2 days 22:15:59″.

bing brought me to the following great article, where Mosha explains how [...]

After deploying an Excel file to Excel Services on a new MOSS Server I got the following error:
Data Refresh Failed: Unable to retrieve external data for the following connections:
<<connection>>
The data sources may be unreachable, may not be responding, or may have denied you access.
Verify that data refresh is enabled for the trusted file location [...]

Excel 2007 is great tool for browsing OLAP cubes. But 1 thing a lot of people don’t know about or at least don’t use enough, is Member Properties.
When they want to add a property of a specific attribute, they just check this item in the field list. By using it this way, you’re kind of [...]

Today I deployed some SSIS packages to a test environment. These packages needed to import some excel files to a certain database. Testing the packages resulted in the following error:
Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0×80004005.
An OLE DB record is available. Source: “Microsoft JET Database Engine” Hresult: [...]