The SSISMasterLog and the SSISDetailLog tables are used to store the status of synchronization where the ProjectID and SiteName are the keys for extracting project specific rows from the details table.
These tables contain the following fields:
Column |
Type |
Comment |
EventKey |
int |
IDENTITY(1,1) NOT NULL |
ProjectID |
varchar(20) |
NULL |
LastRunDateTime |
datetime |
NULL |
Status |
varchar(10) |
NULL |
SiteName |
varchar(100) |
NULL |
Column |
Type |
Comment |
EventDetailKey |
int |
NOT NULL |
EventKey |
int |
IDENTITY(1,1) NOT NULL |
OperationType(Delete/Insert) |
varchar(10) |
NULL |
PackageName |
varchar(100) |
NULL |
EventDescription |
text |
NULL |
RecordCount |
int |
NULL |
LogTime |
datetime |
NOT NULL |
Along with the Controller event log, this information is useful for investigating configuration, permissions, and performance issues.
Introduction to Data Warehouse
Data Warehouse Tables and Views
Changing the Project Synchronization Retry Interval Settings