Execution result to be stored in db table.

[fpatou]

hello

Would it be possible to store execution result in a db table saying package is ok or not :

run_key/project/packages/analysis_result (0,1)/Run_Date_Time.

with such table we can focus on packages having some issues and even be informed each day that something goes wrong and fix it.

Regards

[keif888]

This could be done as an additional piece of metadata stored against the package, where successful, BUT when it fails, you really don't want anything left in the current set of tables, as it results in corrupted data.

And there is the difficulty of keeping track of what is being analysed at the point of an exception.

I'll look at adding an analysed object table into the repository rollback command, which stores the state of each major container analysed (SSIS Package, Database, Cube). Suggestions are welcome on this before I try and build something.