Open topic with navigation

ETLHISTORY (4.0SP20)

Top
Primary Key
Foreign Key Fields
Fields
Indexes

History of the SSIS packages that have run for OLAP data sources

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
OLAPDATASOURCEID	uniqueidentifier	false	OLAPDATASOURCE.ID	FK to OLAPDATASOURCE

Fields
Field	Field Type	Null	Notes	Description
ETLCONTROLID	int	false	0
ISPARENT	bit	false	0	True if this is the master parent package
DATAWINDOWOPEN	datetime	true		The start of the data window for the ETL.
DATAWINDOWCLOSE	datetime	true		The end of the data window for the ETL.
ETLENDTIME	datetime	true		The time the ETL finished.
ETLSTARTTIME	datetime	false		The time the ETL started.
COMPLETED	bit	false	0	The package completed.
SSISPACKAGENAME	nvarchar(255)	false	''
SSISPACKAGEPATH	nvarchar(255)	false	''
SSISUSERNAME	nvarchar(500)	false	''
SSISMACHINENAME	nvarchar(500)	false	''
SSISEXECUTIONINSTANCEGUID	uniqueidentifier	false
NUMROWSADDED	bigint	false	((0))
NUMROWSUPDATED	bigint	false	((0))

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_ETLHISTORY_ETLCONTROLID	ETLCONTROLID	False	False	False
IX_ETLHISTORY_ETLENDTIME	ETLENDTIME	False	False	False
IX_ETLHISTORY_ETLSTARTTIME	ETLSTARTTIME	False	False	False
IX_ETLHISTORY_OLAPDATASOURCEID	OLAPDATASOURCEID	False	False	False
IX_ETLHISTORY_SSISEXECUTIONINSTANCEGUID	SSISEXECUTIONINSTANCEGUID	False	False	False
PK_ETLHISTORY	ID	True	True	True