Hi, I need to extract data from SQL Server Analysis to SQL Server. I created an OLEDB connection for Analysis Services, and then I use the OleDb Source in Data Flow Task to enter with my MDX query. When my MDX returns data, works. But when my MDX doesn't return any data, the task returns the follow error: "No column information was returned by the SQL command" Using a linked server and the OPENQUERY command, the same error occurs. How can I fix that? To SSIS work independent of the data. Thanks PS.: Sorry for my english.

Hi, I have answered some questions about the MDX query or the comparison of MDX query result and SQL result. We can use MDX to load data from analysis service and save data into database. Yes, we need to use linked server and Openquery, please refer to below links - http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/37c86657-385a-4da0-af33-4bbec1fbe7fe http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/afe4530f-d38a-4dae-8003-1171bf00bb36 http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/60ccd497-41b3-4838-b01c-2010b9955133 http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/295c73a9-8041-406a-a038-39ef18410b1e hope it can help you! Please vote if it's helpful and mark it as an answer!

Hi, can you post your MDX ? Hope this will help you !!! Sanjeewan

Hi Simon Lv, I read the links, but not help me too much, because in this links the topics are about how to do MDX query in SSIS, but my MDX works fine, the problem just is when the MDX doesn't return data. Thanks for reply. Hi Sanjeewan Kumar, Here is my MDX, I replaced some names, but the structure is equal: SELECT NON EMPTY { [Measures].[Qt Quotation], [Measures].[Qt Items]} ON COLUMNS, NON EMPTY { ([Dim Date].[Calendar].[Month].ALLMEMBERS * [Dim X].[Cod X].[Cod X].ALLMEMBERS * [Dim X].[Cod Y].[Cod Y].ALLMEMBERS * [Dim X].[ID Z].[ID Z].ALLMEMBERS) } ON ROWS FROM ( SELECT ( { STRTOMEMBER("[Dim Date].[Calendar].[Date].&[" + Format(Now(),"yyyyMMdd") + "]") } ) ON COLUMNS FROM [Cube])

More experienced people are there, they may focus on SSAS and MDS queries, I suggest you can move your question or start a new thread there, it will help you find solutions from others quickly. I eager to help you, but I'm not able to find the reason. Please vote if it's helpful and mark it as an answer!

Ok. Thanks!!!

hey Sanjeewan Kumar, have u got the fix for this? even am facing the same issue..if you got the fix then plz share :) thanks in advance

Hi FB_Dev..... Have you got the solution to your Problem. I am facing the same problem as yours. I am not able to map the columns When MDX returns Empty DataSet. Appreciate your help. Thanks.reddy@sql