Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Current199
Starting Member
3 Posts |
Posted - 2011-08-06 : 07:06:00
|
Hi,After processing my ETL package which loads data into the cube, how do I ensure and confirm that my cube has been processed?Current |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-08 : 04:40:46
|
you can use a control table for that. in your package just add a sql task to populate this table with processing complete record and date processed once your step to process cube is over.WHile package is executing you can go to backend and check this table and can confirm processing is complete once you see this record populated with current days date.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|