I would probably use an Expression on the variable and pre-pend the full path to it. Alternatively, you could use a second variable to hold the path and perhaps...

Absolutely true!

Not so sure...

Out of interest, how are you currently executing the packages? Via BIDS? Via SSMS? Commandline? DTSRunUI? If you opt for theUI or Cmdline options, you...

Have never heard of the Feature Pack being installed on demand, but I'll take your word for it.

If, when logging in to your machine, these users have no access problems,...

Hopefully not over-simplifying the problem here but it would appear you're simply counting the appointments and determining that each of these is therefore an hour.

So, why not simply add...

Just to confirm, you say your operating system is Server 2003, but the images look remarkably like XP - you're definitely on Win2003??

When you say they accessed it from your machine, am assuming you mean they logged in with their own credentials, not just using yours right? If so, it *sounds*...

Hey Mark,

Just catching up on your progress, sounds like you're getting close. A long time ago we had tried to do something similar (i think it was back on...

Good to hear you got it. PM me with what you think. I ran (well, technically 'tried to run') ~ 52MM rows through it on Sat night/sun morning...

Hey Mark,

For the resolution of current level value compared to parent, you could try using something along the lines of (very rough pseudo code)

(([Measures].[AvgScreenViews]) - (Axis(0).CurrentMember.Parent, [Measures].[AvgScreenViews])) / (Axis(0).CurrentMember.Parent, [Measures].[StdDevs])

So...

Hey Mark,

Not sure I follow where/why you want 'calculated dimensions'? This link [/url]is from someone who is doing something very similar to what I'e done previously using the...

@ben - they *can* be bound, i'm guessing you saw the install option (it's an either-or option) to install either 08R2 (bits) or AS into a MOSS farm. The...

You should be able to use Gemini with just Office (actually just Excel) and the add-in. There is a 'SQL Server Gemini Add-In for SharePoint 2010' that's sued to...

Maybe off topic, or obvious to others, it *looks* like additional descriptions are effectively member properties, so depending on the client they won't show up in any list of attributes...

I've seen something similar when a client didn't have the attribute relationships set correctly (in that case, not set at all) - the processing and query times took a hit...