Welcome to EMC Consulting Blogs

April 2006 - Posts

• SSAS: System.Data.OleDb.OleDbException

  A .Net developer colleague of mine was recently trying to connect to SQL Server Analysis Services (SSAS) ona remote server from an ASP.Net app that he was running on his development workstation. Upon doing this he was getting the error that you can see Read More... Posted 27 April 2006 09:29 by jamie.thomson | 1 Comments Filed under: SQL Server Analysis Services, ssas

• SSIS: Another SP1 problem

  Update below Another issue with SSIS SP1 has come to light that people need to be aware of. This one is in relation to the SSIS service not starting. Here's the error that you may get: "The SQL Server Integration Services service failed to start due to Read More... Posted 26 April 2006 23:15 by jamie.thomson | 7 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: Warning - don't install SP1 for SSIS until you've read this.

  For those of you that have not read Simon Sabin's latest blog post you need to be aware of a potential issue with SP1 before you install it. Pre-SP1, any dates within a SSIS package were interpreted according to the regional settings of the machine on Read More... Posted 26 April 2006 19:22 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: SP1 released

  As I'm sure the proverbial world and his equally proverbial dog will know, SQL Server 2005 SP1 has been released. Brian Knight has published a list of the documented features for SSIS here: http://whiteknighttechnology.com/cs/blogs/brian_knight/archive/2006/04/20/150.aspx Read More... Posted 23 April 2006 19:54 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS

• Interesting reads

  If you're interested in BI solutions on the Microsoft platform and you have nothing better to do then you could do worse than readig a couple of whitepapers that I have recently encountered: ETL Performance: Unisys and Microsoft SQL Server Speed Up The Read More... Posted 09 April 2006 11:29 by jamie.thomson | 2 Comments Filed under: SQL Server 2005, SQL Server Integration Services, SQL Server Analysis Services, SSIS, ssas

• SSIS: Whitepaper on Performance Tuning Techniques

  I have recently come across a SQL Server Iintegration Services performance tuning paper here: http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx that I highly recommend reading for SSIS practitioners. It covers important issues such as: Read More... Posted 09 April 2006 08:45 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task

• SSIS: Persistent Oracle Connector

  Those of you that are using SSIS in conjunction with Oracle will have (or should have) read Donald Farmer's blog post that details some of the issues that you need to be aware of. Donald himself states "I do not expect that Microsoft will write an Oracle Read More... Posted 07 April 2006 13:06 by jamie.thomson | 13 Comments Filed under: SQL Server Integration Services, SSIS, Oracle

• SSIS: Concurrently running packages

  Updated at the bottom Concurrent/parallel execution is not a particularly hot topic in SSIS. In the future I expect functionality to be introduced into SSIS to enable things such as spreading parallel executing tasks over multiple boxes and seperating Read More... Posted 03 April 2006 21:38 by jamie.thomson | 11 Comments Filed under: SQL Server Integration Services, SSIS, Checkpoints

• SSAS: Microsoft buys ProClarity!

  What kept them? http://www.microsoft.com/presspass/press/2006/apr06/04-03ProClarityPR.mspx Assuming they give this away with Reporting Services you can kiss a fond farewell to Panorama. Although Panorama's recent partnership with SAP now starts to make Read More... Posted 03 April 2006 20:57 by jamie.thomson | 2 Comments Filed under: SQL Server Analysis Services

• SSIS: A use for the XML type with the Analysis Services Processing Task

  Here's a little tip for you. Some database pros are skeptical about the arrival of the XML data type in SQL Server 2005. They see it as an opportunity for cowboy developers to store all of their data in a single field with no regard for atomicity, normalisation Read More... Posted 03 April 2006 13:42 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SQL Server Analysis Services, SSIS

• SSAS: Foodmart 2005

  People that have used SQL Server Analysis Services prior to v2005 will be failar with the sample Foodmart database that was provided with the product. That has now been replaced by the AdventureWorks sample database instead. For those of you that want Read More... Posted 02 April 2006 13:49 by jamie.thomson | 0 Comments Filed under: SQL Server Analysis Services

• SSIS: DTS Connections and SSIS Connection Managers

  A post appeared on the SSIS forum today in which the poster was getting slightly confused about the use of SSIS Connection Managers and how they differ from DTS Connections so I thought it would be a good idea to illustrate the differences here to hopefully Read More... Posted 02 April 2006 13:13 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, connection manager, RetainSameConnection