Blogs
Welcome to EMC Consulting Blogs Sign in | Join | Help

Welcome to EMC Consulting Blogs

Browse by Tags

All Tags » SQL Server Inte... » ssas

  • 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). I looked into using XML for Analysis (XMLA) to do this but after some trial and error decided ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on September 15, 2008

  • 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 due to lack of resource issues on the Analysis Server. Those issues needed sorting ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on July 18, 2006

  • 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 Process - Understand how 64-bit computing can dramatically increase performance of ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on April 9, 2006
EMC2, EMC, and where information lives are registered trademarks of EMC Corporation.
All other trademarks used herein are the property of their respective owners.                  
© Copyright 2009 EMC Corporation. All rights reserved.                                                    
Powered by Community Server (Personal Edition), by Telligent Systems