Solved

Does it possible to use SSIS to retrieve data from a cube using MDX queries?

Posted on 2012-04-10
13
891 Views
Last Modified: 2016-02-15
Does it possible to use SSIS to retrieve data from a cube using MDX queries?  Thanks.
0
Comment
Question by:thomaszhwang
  • 4
  • 3
  • 2
13 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 37831965
SSIS allows data retrieval from any source for which you've got an OLE DB driver.  There is an OLE DB driver for SSAS, so yes, you can retrieve data from a cube.

On SSIS 2008, the driver is labelled "Microsoft OLE DB Provider for Analysis Services 10.0".
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 37832148
hi, yes as Valentino said, it could get the data from SSAS but not using MDX, just a straight load connection.
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 37832238
Hey Jason,

Why not MDX?  I tried it out (using the regular OLE DB Source in the data flow) and it seems to work fine (if you ignore the warning)?

Regards,
V.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 37832275
Hey Valentine,

Oh really! excuse my ignorance then, sorry...I should try it then

Thanks for letting me know that
Jason
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 37832367
Repeat after me (x100): "I will try it out before commenting" ;)
0
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 37832535
don't have time.... I'll cheat and use:     Replicate ("I will try it out before commenting", 100)
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 37832560
Good one! :)

Thomas: sorry to get a little off topic here, just let us know if you need further info on this.
0
 

Author Comment

by:thomaszhwang
ID: 37900435
whatever...
0
 

Author Comment

by:thomaszhwang
ID: 37916800
Thanks.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Count with a subquery showing details 10 43
sql server insert 12 30
SQL Server 2012 - Merge Replication Issue 1 21
Sql Server group by 10 27
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question