Hi I have one requirement. SSIS package source is Cube Source, Source Oldb time I put into sql query mode in MQX Query. That MDX Query level 2 filters are there how to add that filters in SSIS Package level. I'm trying the following way, But error is occurred. Please send me the solution. How to Access the MDX query parameters in SSIS Source level

Hi, You can't do what you are trying to do. You need to set up a linked server to your analysis server on your SQL box and then embed your MDX query in an Openquery statement (sample syntax below). In your SQL query, choose "SQL Command from variable". You can make your MDX dynamic via an expression on the variable. Use other package variables in your expression to alter the dates. SELECT * FROM OpenQuery(LINKEDSERVERNAME,' WITH MEMBER........' So, the expression on the variable will look like this: "SELECT * FROM OpenQuery(" + @[User::SSASServer] + ",' WITH MEMBER . WHERE {null:[Date].[Date].[" + @[User::MDXQueryDate] + "]}; ')" Please mark as answered if this solves your problem, or mark as helpful. Thanks

I want Package level. Through MDX Query I put into oldb source level. In MDX Query level parameters are there. How to pass the MDX parameters to load into target table ?

Try another way, transfer them to SQL first, then add filter as the WHERE clause . SELECT 'Column1', 'Column2' ... FROM OPENQUERY (LINK_SERVER,'MDX Query') WHERE... Filter.. Please refer to my other answers about the MDX , Link Server and OPENQUERY clause. http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/60ccd497-41b3-4838-b01c-2010b9955133 http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/afe4530f-d38a-4dae-8003-1171bf00bb36 http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/fd4ef019-bf55-434c-82c9-b32e2d18aeaa http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/37c86657-385a-4da0-af33-4bbec1fbe7fe Please vote if it's helpful and mark it as an answer!

Good Information.