blogs.conchango.com

Browse by Tags

• AMO
• Scripting
• SQL Server 2005
• ssas
• SSIS
• Writer
• XMLA

• SSIS: Create Analysis Services partitions from a SSIS package

  I have recently been working on a project implementation that incorporated SQL Server Analysis Services (SSAS) and there was a requirement to be able to create partitions on-the-fly from our ETL process running on SQL Server Integration Services (SSIS). Read More... Posted 15 September 2008 14:06 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SQL Server Analysis Services, SSIS, Scripting, ssas, Writer, XMLA, AMO

• SSIS/SSAS: Process SSAS dimensions and measure groups individually

  On my current project I am implementing SQL Server Analysis Services (SSAS) and recently I was having a problem doing a full process of my cube. I've got many many measure groups in the cube each containing twelve partitions and the cube process was hanging Read More... Posted 18 July 2006 12:56 by jamie.thomson | 17 Comments Filed under: SQL Server Integration Services, SQL Server Analysis Services, SSIS, ssas, XMLA Attachment(s): ProcessAllDimensionsAndMeasureGroups.zip

• 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: 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