tag:blogger.com,1999:blog-3367381022309902019.post4184464835296146141..comments2024-01-29T22:20:13.760+10:30Comments on SQL Server Business Intelligence and Data Warehousing: SSIS - SSAS as Data Source - MDX Query Slow (Because it’s Executed Twice!)Jakub Khttp://www.blogger.com/profile/05838768926896675366noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3367381022309902019.post-76877569935741470722016-11-30T19:29:19.010+10:302016-11-30T19:29:19.010+10:30Hello, I found this article when I search for MDX ...Hello, I found this article when I search for MDX performance to use SSAS to SQL server by using SSIS. Thanks a lot for information first. However I was not able to use the ADO.NET connection when I set the Extended properties as yours and resulted in an error because data isn’t compatible with execution mode prepare like Ole DB. May I ask if you had a solution for this or if you could share whole connection string then that will be great.keremyucelhttps://www.blogger.com/profile/00507994880670105322noreply@blogger.com