title: Configuring an MDX query on SSIS
body: <p><a href="https://i.stack.imgur.com/6IpuU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6IpuU.png" alt="enter image description here"></a>Hi I am having troubles configuring the SSIS task to run an MDX query. 
  The parse works fine but it doesn't allow me to display the different columns of the query to map it </p>
  
  <p>Here is the query i used:</p>
  
  <pre><code>SELECT [Measures].[# Consumers] ON 0,
        [Company].[Company Country Code].[Company Country Code].MEMBERS ON 1
  FROM _CDM
  </code></pre>
  
  <p>The Error thrown is:</p>
  
  <blockquote>
    <p>No Column information was returned by the SQL Command</p>
  </blockquote>
  
  <p><em>Error snapshot</em></p>
  
  <p><a href="https://i.stack.imgur.com/S4kAD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S4kAD.png" alt="enter image description here"></a></p>