IEtlPlainDataConsumer

Description

The IEtlPlainDataConsumer interface is used to work with a data consumer.

Comments

To work with XLS, MDB, DBase providers in x64 OS, it is necessary to have the following drivers:

If MS Office is not installed and the corresponding provider is not found, the message "OLE DB provider Microsoft.ACE.OLEDB.12.0 is not found" is displayed.

The following data consumers can be specified in the Consumer property:

Properties

  Property name Brief description
ClearConsumer The ClearConsumer property determines whether it is necessary to clear a consumer before adding records.
Consumer The Consumer property returns import or export object.
KeyFieldNames The KeyFieldNames property determines fields to find identical records in a source and a consumer.
PlainInput The PlainInput property determines input fields list.

Properties inherited from IEtlObject

  Property name Brief description
ConnCompId The ConnCompId property determines index of connected component of ETL task object.
Description The Description property determines description (annotation) of ETL task object.
Id The Id property determines identifier of ETL task object.
InputType The InputType property returns input type of ETL task object.
IsActive The IsActive property returns whether an object is included into ETL task.
Name The Name property determines name of ETL task object.
ObjectType The ObjectType property returns type of ETL task object.
ObjectTypeName The ObjectTypeName property returns a name of ETL task object type.
OutputType The OutputType property returns output type of ETL task object.
Task The Task property returns the ETL task, in which an object is created.

Methods

  Method name Brief description
Edit The Edit method creates a data consumer copy for editing.
FillDefault The FillDefault method fills fields based on data about consumer fields.
Save The Save method saves results of editing.

Methods inherited from IEtlObject

  Method name Brief description
Remove The Remove method removes ETL task object.

See also:

Etl Assembly Interfaces | IEtlPlainDataBulkConsumer