Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSAS List partition ID using AMO in SSIS

Answered SSAS List partition ID using AMO in SSIS

  • Wednesday, January 02, 2013 9:00 PM
     
     
    Sign In to Vote
    0

    Experts,

    I have a requirement to get the list of ssas partitions in ssis. I think AMO is the only way out.

    I have "n" cubes, "m" Measure Groups and "x" partitions. So basically I have to run foreach loop thorugh each of the objects. Can any one please help me with the ssis script task code?

    Thanks in advance!

    Shailly - If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".


    • Edited by Shailly Wednesday, January 02, 2013 9:01 PM
    •  
     

All Replies

  • Thursday, January 03, 2013 1:06 PM
     
     Answered
    Sign In to Vote
    1

    Hi Shailly,

    The link below might be helpful to you  

    http://www.ssas-info.com/VidasMatelisBlog/11_ssis-package-that-process-all-partitionsmeasure-groupscubes-in-one-database

    http://www.ssas-info.com/VidasMatelisBlog/13_ssis-package-to-dropcreate-partitions-based-on-partition-list-in-the-sql-server-table

    Please have a look once if it will work out to you.

    Thanks,

    Anil Maharjan

    • Marked As Answer by Shailly Thursday, January 03, 2013 10:30 PM
    •  
     
  • Thursday, January 03, 2013 1:35 PM
     
     
    Sign In to Vote
    0

    I've read that these extensions help to find that info:

    http://asstoredprocedures.codeplex.com/

    MVP MCT MCTS Daniel Calbimonte

    http://elpaladintecnologico.blogspot.com

     
  • Thursday, January 03, 2013 10:32 PM
     
     
    Sign In to Vote
    0

    Thanks Anil. I got the solution from link #1. Appreciate your help buddy!

    Shailly - If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".