Error JOB And SSIS

[jepe666]

I create cube in SSAS, i must reprocess each dimension to update new data..I using SSIS package to process them,but it doesn't work..
Step create ssis package:
1.add connection manager
2.create analysis services processing task (process cube and all dimension)
3.deploy it
4.create job in sql server agent
5.run it
what should i do?

 

[MDXer]

what is the error?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[jepe666]

I got error: error the OLAP storage engine. The attribute key not found..
That error shown when run SSIS package and when I process cube..
I know that error happened b'coz there is data inserted in dimension.
If I process dimensions manually,not using SSIS package,it works..
Not effecient..Can suggest?

 

[MDXer]

the error is not related to dimension processing but rather measure group processing. The msg means that you have a null SK in a fact record or a SK in the fact record that doesn't exist in the dimension.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck