Working with ETL Task

This section describes operations that are used to work with the ETL Task repository object. The operations enable the user to get information about ETL task objects, create new or remove available data providers/consumers/transformers and other objects, set up their parameters. It is also available to start ETL task for execution and monitor execution status.

Operations

	Operation	Brief description
	CloseEtl	The CloseEtl operation closes an ETL task.
	GetEtl	The GetEtl operation gets ETL task metadata.
	OpenEtl	The OpenEtl operation opens an ETL task and returns the moniker that is required for working with task objects.
	SetEtl	The SetEtl operation changes ETL task metadata.

Operations for Working with Crosstab Mode Settings

	Operation	Brief description
	CloseEtlUnpivot	The CloseEtlUnpivot operation closes data extraction settings in the crosstab mode.
	CreateEtlUnpivot	The CreateEtlUnpivot operation creates data extraction settings in the crosstab mode.
	GetEtlUnpivot	The GetEtlUnpivot operation gets data extraction settings in the crosstab mode.
	SetEtlUnpivot	The SetEtlUnpivot operation changes data extraction settings in the crosstab mode.