Query SSAS Server Properties

• sidewinder6x

  Mr or Mrs. 500

  Points: 535

  More actions

  May 17, 2012 at 11:40 am

  #392280

  Is there a query that I can run against Anaylsis Services that will return the backup folder server property setting? I have an SSIS job I want to run on numerous SQL/AS servers that need to write and read a CSV file. Since this location differs on each server, I'd like to dynamically be able to set this connection string in the package.

• kwe477

  SSC Eights!

  Points: 820

  More actions

  May 18, 2012 at 1:00 am

  #1489496

  Yes, there is. Here's the PowerShell and AMO (Analysis Management Objects) way.

  [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") | Out-Null;

  [Microsoft.AnalysisServices.Server] $srv = New-Object Microsoft.AnalysisServices.Server;

  [string]$ServerName = "Server\Instance";

  $srv.Connect($ServerName);

  $BackupDestination = $srv.ServerProperties.Item("BackupDir").Value;

  $BackupDestination;