search

keif888 / SQLServerMetadata

SQL Server Metadata Toolkit
Microsoft Public License
83 stars 32 forks source link

Execution result to be stored in db table. #29

Open fpatou opened 6 years ago

fpatou commented 6 years ago

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 commented 6 years ago

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.