Hi, I am using Oledb Analysis services 9.0 provider. I have a mdx query in source. I need to parameterize the query which when i did using ?, i got error saying Parameters can't be extracted from sql command. My MDX query is so big that i cant hold it inside a variable. pl suggest me how to proceed. Thanks, Paddy

you can use script task if you query is too large for a variable. and save your results in temp table or file... check this link for reading the SSAS data with script task --Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

you can use script task if you query is too large for a variable. and save your results in temp table or file... check this link for reading the SSAS data with script task --Let us TRY this | My Blog :: http://quest4gen.blogspot.com/