Thanks Steve!

I have a single NT test account I have setup, and assigned the user to a role in Analysis Services that only can see a slice of the corporate...

No dice.  If "Fail package on first error" is unchecked, and the package fails, the job fails as well.

Thanks for the response.

Yes, I could change workflow, however, I am running the DTS package from a job, and I do not want the job to fail (and page the...

Yes, my fault.  I have probably posted this in the wrong forum.

Thanks Kathi.  Is ForceExecutionResult  a SSIS thing, or is it available in SQL 2000 DTS?  Everything I am finding on this property is based on 2005 SSIS?

Thanks again for your...

In addition, here is a pretty good article:

http://www.sqldts.com/default.aspx?204

In the past, I have bcp'd the sysdtspackages table out of the source server, and bcp'd it into the target server.

Hope this helps.

WORKS LIKE A CHARM!!!

Thanks for all of your help Steve!

Regards,

Aneal

I modified and tried this:

WITH

   MEMBER [Measures].[MyKeys] AS

   'Val([dim_company].CurrentMember.Properties("KEY"))'

SELECT

   {[Measures].[MyKeys]} ON COLUMNS,

   {[dim_company].CurrentMember} ON ROWS

From [MyCube]

This also seems to return 0 for the dim_company key.

As far as uniqueness properties,...

Steve, thank you for your help.  Your suggested solution is definitely getting me closer.  However, I am receiving unexpected results.  I used your MDX as the basis for the following:

WITH...