DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
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