Configuring an MDX Request for SSIS
Hi I'm having trouble configuring an SSIS task to run an MDX query. The parameter works fine, but it prevents me from displaying different query columns to map it
Here is the query I used:
SELECT [Measures].[# Consumers] ON 0,
[Company].[Company Country Code].[Company Country Code].MEMBERS ON 1
FROM _CDM
Thrown error:
Column information was not returned by SQL command
Snapshot with error
+3
source to share
1 answer
You can use MDX Select as a source in a data transformation task.
Two important notes:
- Use MS OLE DB Provider for Analysis Services , configure it for your SSAS database
- In the OLE DB Provider for AS, go to the All Properties tab, select the Advanced section and enter
Format=Tabular
for extended properties.
In this case, in the OLE DB Source Editor you can enter your MDX query.
Important: The preview button may not work, you should check the query metadata transition to the Columns tab.
+2
source to share