Error when updating MDX query in an existing old package

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

July 21st, 2015 5:59pm

Found the fix from the below link.

https://books.google.com/books?id=BEgLLCDieqoC&pg=PA288&lpg=PA288&dq=%22Outputs%5BOLE+DB+Source+Output%5D+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.%22&source=bl&ots=TCvNLezPVx&sig=eCO7-x0VkCcjh5ZuEQm8-4e52EU&hl=en&sa=X&ved=0CCUQ6AEwAWoVChMI_t3Xyp_txgIVDgaSCh0tRwcq#v=onepage&q=%22Outputs%5BOLE%20DB%20Source%20Output%5D%20references%20an%20external%20data%20type%20that%20cannot%20be%20mapped%20to%20a%20Data%20Flow%20task%20data%20type.%20The%20Data%20Flow%20task%20data%20type%20DT_WSTR%20will%20be%20used%20instead.%22&f=false

  • Marked as answer by Koti K 6 hours 26 minutes ago
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2015 8:45pm

Hi Koti,

Glad to heard that the issue had been solved and thanks for your sharing. It will be very beneficial for other community members who have similar questions.

Thanks,
Katherine Xiong

July 21st, 2015 9:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics