none
SSAS List partition ID using AMO in SSIS

    Question

  • 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
    Wednesday, January 02, 2013 9:00 PM

Answers

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

All replies

  • 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:06 PM
  • 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 1:35 PM
  • 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".

    Thursday, January 03, 2013 10:32 PM