I have an SSIS package for creating and processing SSAS partitions. But I intend to add a condition in the package so that it can check the cube to determine if a partition exists. If a partition exist, then skip but if not, the partition should be created. Please, any ideas on how I can achieve this? :)

Hi, Please go through this article, it should help you - http://www.ssas-info.com/VidasMatelisBlog/13_ssis-package-to-dropcreate-partitions-based-on-partition-list-in-the-sql-server-table Cheers, ShalinShalin P. Kapadia

Thanks but the code is very long and confusing. I am not coding alot in my package and I am not using partition table. I am just using the BIDS designer. I wanted a solution where I can check the cube, not table, and be able to confirm if the partition I intend creating is already existing in the cube or not. Can I do this?

You can do anything you like with the Analysis Services Command. But the contents of that command are beyond the scope of SSIS - we don't know XMLA here ;) Talk to me now on

Please, can you provide a clear code example that will check if a partition is already existing in a cube or not. :)

Here is the XMLA code that creates a new partition - http://bigorakine.wordpress.com/2009/10/30/create-new-ssas-partition-dynamically-xml-task/ The post says that the SSIS package could be configured in such a way that it doesn't fail if the partition already exists. As mentioned by Todd in his post above, we don't know XMLA here ;) In case you need more information on the XMLA commands, go here - http://msdn.microsoft.com/en-us/library/ms187178(v=SQL.90).aspx Alternatively, you could also ask questions in the SQL Server Analysis Services forum. Cheers, ShalinShalin P. Kapadia