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


Hi, I have an ETL package where the Source is an MDX Query pulling 3 columns from the SSAS 2008 Cube and the Target is a SQl Server 2005 Table. I am passing the MDX Query through a variable in SSIS. The Package is not showing any errors but when I execute the Package an "SQLDUMPER.EXE" popup is coming and then it automatically getting closed in 2 seconds. After this the Package is showing that it is Executed successfully. But nothing is happening in the dataflow. Even the Source is not pulling the Data from the cube. When I execute the MDX query in SSMS it is getting 3 million records. Please guide me in solving this issue. Any help would be appreciated.. Thanks in Advance.
1 Solution
Reza RadCommented:
usually SQLDumper.exe errors indicates insufficient memory. try to reduce size of data transfer and check it again.
KuldeepReddyAuthor Commented:
Hi There are no issues with Size, I have tried this even then I am getting the same. I am passing my Source query as a variable and in the Variable expression I have given the MDX Query. In the MDX Query Where Clause I need to take the current Year may be I am doing something wrong there. Here is my Query.. In the First Line in the Where clause I have taken DATEPART Function. Is there something wrong with the Function.

WITH MEMBER [Company Financial].[Company Hierarchy].[All Companies].[ Aggregation] AS ' AGGREGATE( { [Company Financial].[Company Hierarchy].[Company].&[2], [Company Financial].[Company Hierarchy].[Company].&[3] }) ', SOLVE_ORDER = 0
       MEMBER [Product].[Category Hierarchy].[NoLIQ] AS '[Product].[Category Hierarchy].[All Categories] - [Product].[Category Hierarchy].[Item Group Major].&[Liquidation Items (LIQ)]'

SELECT { [Measures].[Customer - Total Revenue], [Measures].[Customer - Gross Margin Profit Dollars] } ON COLUMNS ,

{ [Customer].[Customer Code].[All Customers].CHILDREN } ON ROWS  

FROM [Customer Profitability]

( [Posting Date].[Date Hierarchy].[Year].& [DATEPART('YYYY',CDATE(NOW())]
, [Customer Role].[Customer Role].&[2]
, [Company Financial].[Company Hierarchy].[All Companies].[ Aggregation]
, [Product].[Category Hierarchy].[NoLIQ] )

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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