SSIS process ssas task - automatically change partition based on a period range in parameter or table record
Good Day, Please help.
I have ssis pkg that process a cube with partitions but every month i have to change the monthly partition.
i tried using the expression on the process task but that dont work - I want the pkg to select partition based on a record or parameter.
Regards
May 31st, 2012 3:46am
Check this article for implementation.
http://secretsql.wordpress.com/2011/02/06/ssas-dynamic-partition-processing/
Free Windows Admin Tool Kit Click here and download it now
May 31st, 2012 8:24am
Check this article for implementation.
http://secretsql.wordpress.com/2011/02/06/ssas-dynamic-partition-processing/
May 31st, 2012 8:27am
Wow this is great - Thank You
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2012 10:55am
This topic is archived. No further replies will be accepted.
Other recent topics
