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

Don't use a NULL value where the code doesn't allow NULL to be used. — Tab Alleman, Jun 25 '19 at 17:59

score 0 · Answer 1 · answered Jun 25 '19 at 20:04

0

Try replacing localhost with the DataSource=localhost.

Example:

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

References

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

answered Jun 25 '19 at 20:04

Hadi

I think the second part is the OP need +1 – Yahfoufi Jun 26 '19 at 07:58
Replacing localhost with "DataSource=localhost" does not work for me. I had already tried giving complete connection string and well as you said in the above. But not working. somehow in the same machine with 2008 SSIS it was working. i am able to connect. – kabilan Mohanasundaram Jul 03 '19 at 08:08

1 Answers1