I use Team Foundation Server (TFS) for source control of my current data warehouse project with SSIS, SSRS and SSAS but my requirements documents which are mostly word but also Excel, Visio and xMind (Excellent mind mapping diagram software) were … Continue reading
This gallery contains 1 photo.
Have you got missing cubes in your Excel Data Connection Wizard? A customer noticed this yesterday and had spent all afternoon looking for the issue, rebuilding, deploying, processing, deleting and recreating on the server etc. all to no avail. He … Continue reading
Excel Error: There was a problem sending the command to the program 15 August 2012 If you click on an excel file and get this error instead of Excel opening your document and you have followed the MS link to … Continue reading
SSIS 2008 and SSIS 2008 R2 are the same Well pretty much. One big difference is that the ADO.NET Destination has been upgraded. Trouble is that the upgrade is tiny and SQL Server 2008 is not forwardly compatible. If you … Continue reading
This taken from “Behaviour Changes to Analysis Services Features in SQL Server 2012” Cube browser in Management Studio and Cube Designer has been removed The cube browser control that let you drag and drop fields onto a PivotTable structure in … Continue reading
I have a customer for whom I am building a data warehouse solution using SQL server 2008. Source data comes in many forms including SQL Server 2000, SQL Server 2005, flat files (csv), Excel and Informix. SSIS handles connections to … Continue reading
SSRS no longer working. Damn I got this error a few days ago when trying to connect to my local SQL Server Reporting Services. I only wanted to test some functionality and was annoyed that this prevented me from doing … Continue reading
Every day I receive emails from specialist interest groups (Mostly SQL Server) with tips, tricks and articles. One of todays emails mentioned a gotcha with the ISNULL function. I read the rather long winded, slightly repetitive and difficult to follow … Continue reading
