Database Reference
In-Depth Information
• We can write .NET code using AMO to process objects, just as we did
to create and delete partitions. While this works, it usually gives us no
particular advantages over the other methods, will take slightly longer to
develop, and will be harder to maintain. It's a good option when we have
very complex logic determining what needs processing, and it would be too
difficult to implement this logic in the Control Flow.
External applications, for example, the ASCMD utility described in the
following section that can manage processing, can be invoked using the
Execute Process Task.
The ASCMD utility is a command-line tool that can execute XMLA,
MDX, or DMX commands against Analysis Services. A detailed list
of its functionality can be found in its readme at: http://tinyurl.
com/ascmdreadme and the Analysis Services 2008 version can be
downloaded from http://msftasprodsamples.codeplex.com/
releases/ . It's extremely useful in situations where we can't use
Integration Services, but if we do have a choice, then using Integration
Services is always the easiest option.
A simple Integration Services package that performs processing might look
something like this:
 
Search WWH ::




Custom Search