Search code examples
ssisssas

SSAS "MSOLAP100" Connection manager

I have an SSIS package that processes a cube via the "Analysis Services Processing Task".

I have a connection string as follows:

Data Source=<SERVER NAME>;Initial Catalog=<CATALOG NAME>;Provider=MSOLAP.5;Integrated Security=SSPI;

The packages are stored on an SSIS Server and are executed via a windows work flow which will pass the Data Source, Initial Catalog, User ID as well as Password to the Connection Manager as parameters.

SSIS Package Configuration of Connection Managers

I have tested the connection to the Cube on SSDT and it seems to work. However when I execute the package via the workflow or directly from the SSIS Server it does not seem to find the connection. I get the following error:

SSIS Server Error message

According to this article you can only connect to a " You can only connect to an Analysis Services project while developing packages in SQL Server Data Tools (SSDT)."

Has anyone ran into this issue before and is there a work around?

Thanks in advance.

Solution

  • It was a permission issue. The credentials I was using had not been created on the SSAS server.