Brandie Tarvin (6/10/2011)

---

yayomayn (6/10/2011)

---

Yes in your execute SQL task you must map the result of your SQL variable to a variable in the package.

In fact I don't know why you...

Yes in your execute SQL task you must map the result of your SQL variable to a variable in the package.

In fact I don't know why you would need the...

It sounds as if you have defined your variable at the DFT scope rather than the package. Not all "Global" variables are at the package scope either.

Explain more what...

I think if you tried that SSAS would still know that it is a calculated measure being used in the scope.

I had a quick google search and found this from...

By default, you can't use drillthrough with calculated measures. There are ways around it though, as is discussed here:

http://sqlblog.com/blogs/mosha/archive/2008/09/01/drillthrough-on-calculated-measures.aspx

Drillthrough's are expanded upon in the ASSP project on codeplex:

http://asstoredprocedures.codeplex.com/wikipage?title=Drillthrough&ProjectName=asstoredprocedures

Hope this helps...

I can't say I've ever seen this done. I'm skeptical that it is even possible but perhaps you are asking the wrong question. You should maybe ask yourself why you...

Hi,

Assuming the table is called "Vouchers" and assuming I understand what you're after then this should do the trick:

SELECT

Voucher_No

, Bill_No

, CASE

WHEN Amount < 0

THEN

...

The maximum length of a variable expression is 4000 as is discussed here: http://consultingblogs.emc.com/jamiethomson/archive/2009/05/27/4000-character-limit-in-ssis.aspx

Your expression is well under that amount unless your count variable is unbelievably massive in which case...

You need to create another variable to hold the SQL and then pass the value of the existing variable into that.

So create a new variable with a string datatype, in...

Good point.

This was a very quick and dirty solution 🙂