blogs.conchango.com

Browse by Tags

• AMO
• configurations
• Scripting
• SQL Server Analysis Services
• ssas
• Writer

• 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

• Project REAL: SSIS in the real world

  Project REAL is a Microsoft led initiative to build an end-to-end demonstrable BI solution on SQL Server 2005 BI tools (i.e. SSIS, SSAS, SSRS). A paper has been released documenting the experiences gained whilst building the ETL portion of this project Read More... Posted 09 March 2005 23:18 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS, configurations, XMLA