Hi, within SSIS using an process ssas dll task with variable xmla, but the task never completes the xmla returns 2 partitions but within process ssas task - selecting the partitions it runs for 30min This is what the variable is returns & inserted within an ssas dll task it never ends, any ideas ? <Batch xmlns="http://schemas.micros..."> <Parallel> <Process xmlns:..."> <Object> <DatabaseID>SSAS DW Test</DatabaseID> <CubeID>DW Test</CubeID> <MeasureGroupID>Budget Measures</MeasureGroupID> <PartitionID>Budget 2012_06</PartitionID> </Object><Type>ProcessFull</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> <Process xmlns:..."> <Object> <DatabaseID>SSAS DW Test</DatabaseID> <CubeID>DW Test</CubeID> <MeasureGroupID>Sales Measures</MeasureGroupID> <PartitionID>Sales 2012_06</PartitionID> </Object><Type>ProcessFull</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch>

Any reason you don't want to use the Process SSAS Task?MCTS, MCITP - Please mark posts as answered where appropriate.

Hi, Im trying to automate the partition process from a table when new period. Currently i have to do it manually every last day of the month & this is a nice way to manage partition processing via a table.

Hi, Im trying to automate the partition process from a table when new period. Currently i have to do it manually every last day of the month & this is a nice way to manage partition processing via a table. That's indeed a very good reason :) Maybe the syntax is wrong? The example in this article has only one <object>, while you have two. http://msdn.microsoft.com/en-us/library/ms187199.aspxMCTS, MCITP - Please mark posts as answered where appropriate.

I scripted the partition process but my MeasureID in the xmlscript is "Q SELECT Key Date BI1 View Fact Sales" but in BIDS i see the Measure group name & id is "Sales Measures" which i have in my script now when i change the script for MeasureGroupId then the task completes within 2minutes which suggests nothing happened ... clueless any ideas?

The Diemnsions work fine within a batch for multiple objects <Batch xmlns=".."> <Parallel> <Process "..."> <Object> <DatabaseID>SSAS DW Test</DatabaseID> <DimensionID>Customer</DimensionID> </Object> <Type>ProcessUpdate</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> <Process "..."> <Object> <DatabaseID>SSAS DW Test</DatabaseID> <DimensionID>Company</DimensionID> </Object> <Type>ProcessUpdate</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> </Batch>

It looks like i can only process one Partition/Object within an Batch Really?

Thank You - I got it going - MeasureGroupID was incorrect

Thank You - I got it going - MeasureGroupID was incorrect Allright, glad you found the issue.MCTS, MCITP - Please mark posts as answered where appropriate.