title: MDX query not returning rows in SSIS data flow task?
body: <p>So I am browsing a SSAS cube in SSMS and using query designer to build my query.  I am only wanting to return dimensions and not measures.  Here are my steps:</p>
  
  <p>I right click the cube and select browse.  I then drag over the dimensions I want and do not get any results obviously, because I have not selected any measures.  So I then click the 'show empty cells' option, and bam, there is everything I want!!!</p>
  
  <p>From this point I click 'Design Mode' button to reveal the query.  The issue is, when I put this query into a data flow task in SSIS, it doesn't return any rows.</p>
  
  <p>Here is what I have :</p>
  
  <pre><code>   SELECT { } ON COLUMNS, { ([Customer].[Customer].[Customer Number].ALLMEMBERS ) } 
     DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [Customer] 
     CELL PROPERTIES VALUE
  </code></pre>
  
  <p>When I run this in SSMS, I get rows.  When I run in SSIS, I get nothing.  How can I return the same rows in SSIS as in SSMS?</p>