Analysis Services Connection

Declares an 'AnalysisServicesConnection' that points at the 'Adventure Works DW 2008' database on localhost via the MSOLAP.4 provider. The 'Impersonation Level=Impersonate' setting causes the connection to act as the calling Windows identity. Adjust 'Server', 'Database', and the connection string to point at your own SSAS instance and catalog. The connection can be referenced by Analysis Services Processing tasks, Analysis Services Execute DDL tasks, and the cube/dimension processing components in SSIS.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Connections>
    <AnalysisServicesConnection
      Name="AdvWorksCube"
      Provider="MSOLAP"
      Database="AdventureWorksCube"
      Server="localhost"
      ConnectionString="Data Source=localhost;Initial Catalog=Adventure Works DW 2008;Provider=MSOLAP.4;Impersonation Level=Impersonate;"
      />
  </Connections>
</Biml>