March 24, 2011 at 12:48 pm
Hi,
I don't know if this is the correct forum, but here goes.
I am trying to backup ssas cubes but I need to be able to determine if they are being built before starting the backup. There are a number of sql agent jobs that build the cubes via ssis packages. The jobs themselves have set values set which pass the cube names to the ssis packages. I can query sysjobsteps command column to get the command but i need to parse out the command so I can get back the property path and matching value.
/SET "\Package.Variables[CubesRequested].Value";"NameOfCube1,NameOfCube1" /SET
So for the abbove snippet out of the command column the property is \Package.Variables[CubesRequested].Value and the value is NameOfCube1,NameOfCube1
Does anyone know how this can be accomplished, I have tried but I am going nuts just having figured how to dynamicaly backup the cubes:-)
Andrew
March 24, 2011 at 3:13 pm
dont know where my head was, figured this out:-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply