I have an SSIS package which is scheduled to run daily using SQL agent. The SSIS package basically processes an SSAS cube. Once in a while, the job fails and the reason most of
the times is due to the attributes missing in the dimension table. For example, one of the fact tables has account number as a column and it is joined to the account dimension by account number. Sometimes, new accounts get added to the fact table but those
accounts don’t exist in the dimension table.
What we like to do is that when the SQL job fails, we want to know what attribute was missing that caused the cube to fail processing. An email is sent out to a group when the
job fails and so it would be idea if we could include the missing attributes in that email. Any idea how to do this? Thanks in advance.
View Complete Post