I have found a bit of a quirk in the SSAS DDL task and wonder if anyone had come across anything similar. I want it to an MDX script from a variable so the SourceType is Var and the source is User::DimMDXSource. When I paste the script into the value of the var, it only stores the first line because it doesn't seem to store the char returns. I have tried storing it as an expression but it won't evaluate it as an expression, assumingly because the script contains double quotes. The weird thing is, I have another package where I did this and it put the square char returns in upon pasting and actually stores the whole script in the variable value. I copied the package (so I know the settings are fine) but again, when I paste the script it, it only stores the first line. It's quite bizzare. I don't really want to do this as a config package file. How on earth did I get it to work in the first place? Is it to do with some encoding setting somewhere? Anyone know a work around? Thanks Jo It's kind of fun to do the impossible. - Walt Disney

Please Close the post if you already have found the answer.Regards, Chirag Patel (ETL Engineer @C-S-America)

Hi, how about copying your entire code and paste into note pad, after that copy again and paste back where you want to put. Now it should take all the characters. Thank youhttp://sqlage.blogspot.com/