| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 ETLCONTROLID |
int | Default = 0 | ||
| ISPARENT |
bit | Default = 0 | True if this is the master parent package | |
| DATAWINDOWOPEN |
datetime |  |
The start of the data window for the ETL. | |
| DATAWINDOWCLOSE |
datetime | |
The end of the data window for the ETL. | |
| ETLENDTIME |
datetime | |
The time the ETL finished. | |
| ETLSTARTTIME |
datetime | The time the ETL started. | ||
| COMPLETED |
bit | Default = 0 | The package completed. | |
| SSISPACKAGENAME |
nvarchar(255) | Default = '' | ||
| SSISPACKAGEPATH |
nvarchar(255) | Default = '' | ||
| SSISUSERNAME |
nvarchar(500) | Default = '' | ||
| SSISMACHINENAME |
nvarchar(500) | Default = '' | ||
| SSISEXECUTIONINSTANCEGUID |
uniqueidentifier | |||
| NUMROWSADDED |
bigint | Default = ((0)) | ||
| NUMROWSUPDATED |
bigint | Default = ((0)) |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 OLAPDATASOURCEID |
uniqueidentifier | OLAPDATASOURCE.ID | FK to OLAPDATASOURCE |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_ETLHISTORY_ETLCONTROLID |
ETLCONTROLID | |||
| IX_ETLHISTORY_ETLENDTIME |
ETLENDTIME | |||
| IX_ETLHISTORY_ETLSTARTTIME |
ETLSTARTTIME | |||
| IX_ETLHISTORY_OLAPDATASOURCEID |
OLAPDATASOURCEID | |||
| IX_ETLHISTORY_SSISEXECUTIONINSTANCEGUID |
SSISEXECUTIONINSTANCEGUID | |||
| PK_ETLHISTORY |
ID | |
|
|