Issues with OLEDB Connection to Analysis Services SSIS

Was pulling my hair out trying to get the OLEDB SSAS driver to work in SSIS 2012, it worked perfectly in SQL 2088R2, my MDX query would execute and preview correctly in the OLEDB source component,but when I executed the package in SSDT it would fail during pre execute with less than helpful error message. Thankfully I happened to find the post below by Sherry Li, it explains in detail the steps required to setup the OLEDB SSAS Connection to work correctly.

http://bisherryli.wordpress.com/2012/08/14/ssis-113-querying-ssas-cube-with-mdx-from-ssis/

Thanks Sherry, very much appreciated

Advertisements

2 thoughts on “Issues with OLEDB Connection to Analysis Services SSIS

  1. good post. also heard the SSIS 12 comes with a SAP R3 adapter, did you work with this, is it straight forward? thanks guru, had been a long time, hope all is well.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s