Hi,
I have an existing old SSIS Solution that needs to be updated with MDX query. In the query I am using every thing as is but changing only the filter condition. When I try to Preview the data on data flow task, I am getting below error.
utputs[OLE DB Source Output] references an external data type that cannot be mapped to a Data Flow task data type. The Data Flow task data type DT_WSTR will be used instead.
Package without MDX query update is running fine and no issues. I am using SQL Server 2014 and SSDT 12.0.50318.0 version for your info.
I tried updating SSAS connection string with "Format=Tabular" which was missing earlier and still didn't help.
Can you let me know how to fix it?
Thanks,
Koti K