This can be done if you are sending MDX to the cube and returning cellsets to Excel. Otherwise you will probably need to look at a more robust client...

Try setting the step to successful when all files have been loaded.

Steve Hughes

Magenic Technologies

Try commenting out the Response.Write functions. I do not think those are supported in ActiveX scripting. They are ASP functions.

Steve Hughes

Magenic Technologies

What is your current time member? For this to work correctly you will need to be referring to the day not the month.

For instance:

current date = 11/5/03 = [Time].currentmember

ParallelPeriod([Time].[Year],...

I would put them in separate fact tables and cubes for flexibility and logical reasons. By using separate fact tables and cubes you will be able to adapt your...

Can you give us more details about what your Execute Package properties are?

One thing to check on is if the file has been released from the previous load. If the files are not released, then DTS would be waiting for permission...

First of all I would not use DTS to move data into Oracle as it does not do that efficiently.

That being said, make sure your tables are architecturally "clean." ...

Steve is correct. You cannot create a set that spans two dimensions. His linkmember idea is excellent. Here's an example for using the LinkMember function that will...

You may need to check with Microsoft, but I do not believe that AS is supported on Tablet PC. We had some people try to install it on Tablet...

No they are not. AVG uses the count of the non-empty members only to get the denominator. Where SUM/Count will uses the count of all members in the...

You can also stick the select statment into a view.

create view MonthList

as

Select 1 and MonthNum

union

...

I have done this many times to reflect small amounts of static data without...

Double check the options tab in the Transform task. If you have an exception file that is trying to be created, it might not be available to the SQL...

The Execute SQL task in DTS ignores errors returned from stored procedures. I commonly will use a Return value or an output parameter to retrieve the error value and...

This problem is commonly caused because you have referenced the package version in the job statement. Here is a simple way to create your own execution line and use...