question

JainPriyanka-8182 avatar image
0 Votes"
JainPriyanka-8182 asked JainPriyanka-8182 commented

CAN we connect to AAS from visual studio 2013?

Hi ,

I am trying to call Azure AS from SSDT 2013 ( sql server 2014) so that Azure AS get refreshed from SSIS package.

In the package i have used Analysis Services Execute DDL Task and connected to Azure AS and test connection is succeeded.
but when i ran the package it is giving the error
Analysis Services Execute DDL Task : error :The connection string is not valid.

Below is the connection string we are using to connect to AAS

Provider=MSOLAP.8;Data Source=<Data SOurce name>;User ID=<azure userid>;Initial Catalog=<Database Name>;Impersonate

AND tried another one also

Data Source=<Data SOurce name>;User ID=<azure userid>;Initial Catalog=<Database Name>;Provider=MSOLAP.8;Impersonation Level=Impersonate;


Thanks,
Priyanka

azure-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered JainPriyanka-8182 commented

@jainpriyanka-8182 Thanks for using Microsoft Q&A !!
I believe Analysis services DDL task cannot recognize "asazure://" protocol and thus you are getting this error. You can refer to this existing thread which talks about similar issue and try the another workaround. Please let me know how it goes.

Thanks
Saurabh

· 8
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for replying

0 Votes 0 ·

Thanks @jainpriyanka-8182,
Please let me know if the above solutions worked for you or if you have any other questions.

Thanks
Saurabh

0 Votes 0 ·

Currently this is working through package but after deploying in to server tht is failing due to "can't find the class" , I think server don't have latest version of MSOLAP . So waiting version updation of MSOLAP in the server. Once successful in the server then i will update ypu with the same.

0 Votes 0 ·
Show more comments