No votes yet


Overview

Script task to get Analysis Services object property.


Setup

The script has the following parameters:

  • Type - type of object. It can be: Server, Database, Cube or Dimension.
  • Connection - MSOLAP90 connection manager selection.
  • Database - Analysis Services database selection.
  • Cube - Analysis Services cube selection.
  • Name - object property selection.
  • ResultVariable - package variable where property value is stored. The type of variable should be Object.

Requirements

Depends on COZYROC Script Task Plus for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • Microsoft.AnalysisServices
  • CozyRoc.SSISPlus

ScriptMain