ETLCONTROL
Primary Key
| Primary Key | Field Type |
|---|---|
| ETLCONTROLID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| PARENTETLCONTROLID | int | yes | ||
| ISPARENT | bit | Default = 0 | ||
| DATAWINDOWOPEN | datetimeoffset | |||
| DATAWINDOWCLOSE | datetimeoffset | |||
| ETLSTARTTIME | datetimeoffset | |||
| ETLENDTIME | datetimeoffset | yes | ||
| LOADISCOMPLETE | bit | Default = 0 | ||
| SSISPACKAGENAME | nvarchar(255) | |||
| SSISPACKAGEPATH | nvarchar(255) | yes | Default = '' | |
| SSISSTARTTIME | datetimeoffset | yes | ||
| SSISUSERNAME | nvarchar(500) | yes | Default = '' | |
| SSISMACHINENAME | nvarchar(500) | yes | Default = '' | |
| SSISEXECUTIONINSTANCEGUID | uniqueidentifier | yes | ||
| NUMROWSADDED | bigint | yes | ||
| NUMROWSUPDATED | bigint | yes |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ETLCONTROL_SSISPACKAGENAME | SSISPACKAGENAME | |||
| PK_ETLCONTROL | ETLCONTROLID | yes | yes | yes |