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