SSDT Microsoft.AnalysisServices.Server connect throwing "Value cannot be null error"

Question

I am trying to connect OLAP cube server from SSIS using script task(C# .net). I am getting following error

"Value cannot be null".

I am using the SSDT 2017.

The same was working from BIDS 2008. But not working on the SSDT 2017.

Microsoft.AnalysisServices.Server server = new Microsoft.AnalysisServices.Server();
server.Connect("localhost");

Error Message : Value cannot be null. Inner Exception : null

Answer 1

Try replacing localhost with the DataSource=localhost.

Example:

Microsoft.AnalysisServices.Server server = new Microsoft.AnalysisServices.Server();
server.Connect(@"DataSource=localhost");

References

• Connect to an existing tabular server and database

---

I suggest refering to te following article for a step by step guide to connect to SSAS multidimensional database from Script Task:

• Create SQL Server Analysis Services Partitions using AMO