Question about scripts and transactions

I am writing a package which will identify new partitions for my cubes, create them, and then process them. I have an XMLA file which is executed to process the partitions in a single task, which is built up within a loop. If I set the transaction level to required, will this mean that if one partition fails to process, the others will roll back?

Hope this makes sense!

Thanks in advance

Rudy, we are investigating the same process for our cubes. We would like to apply partitioning by day to the SSAS cube via an ETL job that runs after the load (or when appropriate, I'm not a pro at partitioning).

Were you successful with this task and do you have an example or better yet an example package that I could base our process on? Thanks for your time!

Romeo

Question about scripts and transactions

I am writing a package which will identify new partitions for my cubes, create them, and then process them. I have an XMLA file which is executed to process the partitions in a single task, which is built up within a loop. If I set the transaction level to required, will this mean that if one partition fails to process, the others will roll back?

Hope this makes sense!

Thanks in advance

Rudy, we are investigating the same process for our cubes. We would like to apply partitioning by day to the SSAS cube via an ETL job that runs after the load (or when appropriate, I'm not a pro at partitioning).

Were you successful with this task and do you have an example or better yet an example package that I could base our process on? Thanks for your time!

Romeo

Question about debugging

Greetings: I have a question about debugging or stepping through DTS
package Active X scripts. When I hit a bug Microsoft Development
Environment pops up the script and highlights where the error occurred.
I can use the Immediate pane to find out the values in the variables,
but I can't set breakpoints or step through or out of or back into the
script or even change it. Is this possible? I am having trouble
finding references to this. I appreciate any help.

Thanks!

--Rowan"phantom" <phantomtoe@.yahoo.com> wrote in message
news:1106667854.668001.62480@.c13g2000cwb.googlegro ups.com...
> Greetings: I have a question about debugging or stepping through DTS
> package Active X scripts. When I hit a bug Microsoft Development
> Environment pops up the script and highlights where the error occurred.
> I can use the Immediate pane to find out the values in the variables,
> but I can't set breakpoints or step through or out of or back into the
> script or even change it. Is this possible? I am having trouble
> finding references to this. I appreciate any help.
> Thanks!
> --Rowan

I've never tried it myself, but it looks like debugging ActiveX in DTS is
somewhat limited:

http://msdn.microsoft.com/library/d...ddf_ax_0bg3.asp
http://groups.google.ch/groups?hl=e...EQ%40sqldts.com

Simon