DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
No votes yet


Script task to get Analysis Services object property.


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.


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