Thanks rewriting the MDX code worked in calculated measure.

From my experience so far in MDX is limited.

I think you need to bring those other FACT tables into your Data Source View for starters. Next, you can...

Forumers,

Thank you for all your very fast replies. I have found a workable solution. I can just add a comma between recipients in my toaddress string and that...

I will agree with John. You can make a composite key via the wizard. Does your schema only include Dimensions to one FACT or do you have any...

Scott,

Thank you for your quick response and your suggestion did the trick.

Mickiel

Thank you for you response and example. I am currently testing and I will let you know the outcome, again thanks.

Please give me an example...

Please review attached file I have added with screen shot. I want to setup a command file instead of using command line. 😎

Ten Centuries (Lynn), thank you for your feedback.

Just to be sure, when deploying your package to the production servr, did you run the Package Installation wizard by double...

Grasshopper, first thank you for your response and good questions.  Let me see if I can answer best of my knowledge here.

How did you accomplish the deployment to your production system? 

I deployed the SSIS Package to our Data Warehouse server from MS Visual 2005 by File| Save Copy of Package.dtsx As. ...