Did you change your path reference in Testbatch2 (for testbatch) to be the full path?

that's all doable, so what's the SSIS problem that you have?

Slight mod required (for me anyway) to the testbatch2 file --> I had to specify the path to the inner batch file, I guess my exeucting location from within...

Um, you can't exactly 'monitor' an event that has already occurred. You can most definitely monitor events moving forward.

One place to start...

So what went wrong with the prior install? I've installed 2008, 2012 and even 2014 all on one machine before with no issues (obviously not a prod machine).

Your 4GB...

Ha Koen, yes and BI edition. I was going old school and looking only at the 2008 editions and supported features.

If you're truly running SQL Express Edition, then no dice - you don't get SSAS with Express, only Standard and Enterprise.

Not sure that you need a calc member for this.

One approach you could try is in the cube designer, dragging/add the task key to the measures area and change...

Is the table keyed or have other indexes? Have a surrogate key? If you have some of these, you might be able to get your deletes to run...

It's not show stopping but the management is a bit of a PITA. You would be well served to create some management procs that do things like dropping and...

Poor man's partitioning (though, this was the way we all used ot have to do it 😀 ) -> Partitioned Views. Details from msft here.

a4apple - i think he had provided his own tsql, but is looking for an 'equivalent' in MDX. But as stated previously, he's given no details on the dims/measures...

asranantha,

MDX is used against OLAP sources (ie 'cubes'). You've provided no details of your cube at all, only a DB table.

Have you built your cube yet? If...

For questions 2&3, I recommend you Google those and come back to the forum if you find answers you can't seem to grasp.

Question 1 - either you took...

Sounds like you're (in general) doing the 'right' thing and using surrogate keys for dimension rows and then using lookups/joins to populate the appropriate FK (surrogate) to the fact.

but -...