• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 784
  • Last Modified:

MDX mapping to SSIS

Hi Experts ,

I have MDX queries that result needs to be populated in SQL table for the  I am using SSIS package

SSIS reconize Direct members of infocube not a calcualted level memebrs that query level or session level, how to do that please let me know

if you have any other solution please let me know,

  • 2
1 Solution
For population of SQL table is the best the usage of openquery statement. You define a linked server to your analysis server. Results of openquery can be inserted into an existing or a new query - from SSIS you can execute a simple stored procedure.
shore-supportAuthor Commented:
Yes, You are correct but we dont use linked server it overburdens the problems.

that is why we have selected SSIS package.

shore-supportAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now