EtlObjectType

Description

The EtlObjectType enumeration contains types of ETL task object.

It is used by the following properties and methods:

Available values

Value Brief description
3 PlainDataJoin. Transformation: join.
4 PlainDataUnion. Transformation: union.
5 PlainDataSplit. Transformation: split.
6 PlainDataDeduplicate. Transformation: deleting duplicates .
7 PlainDataGroup. Transformation: grouping.
8 PlainDataFilter. Transformation: filtering.
9 PlainDataSort. Transformation: sorting.
10 PlainDataMapper. Transformation: mapping.
11 PlainDataUser. Transformation: user algorithm.
32 CodeBlock. Procedure.
33 SQLCommandBlock. DBMS command.
81 PlainLink. Objects link.
100 PlainDataMetabaseProvider. Import from repository.
101 PlainDataAccessProvider. Import from Access.
102 PlainDataExcelProvider. Import from Excel (97-2003).
103 PlainDataExcelConsumer. Export to Excel (97-2003).
104 PlainDataDbaseProvider. Import from DBase.
105 PlainDataParadoxProvider. Import from Paradox.
106 PlainDataXmlProvider. Import from XML.
107 PlainDataWebProvider. Import from Web-page.
108 PlainDataTextProvider. Import from text file.
110 PlainDataOleDbProvider. Import from OLEDB.
111 PlainDataUserProvider. Import from user source.
112 PlainDataVfpProvider. Import from Visual FoxPro.
113 PlainDataExcelProviderEx. Import from Excel (xlsx).
200 PlainDataMetabaseConsumer. Repository consumer.
201 PlainDataAccessConsumer. Export into Access.
202 PlainDataDbaseConsumer. Export into DBase.
204 PlainDataXmlConsumer. Export into XML.
205 PlainDataTextConsumer. Export into text file.
207 PlainDataOleDbConsumer . Export into OLEDB.
208 PlainDataUserConsumer. Export into user consumer.
209 PlainDataVfpConsumer. Export into Visual FoxPro.
210 PlainDataSqlCommandConsumer . Consumer: DBMS command.
211 PlainDataCopy. Source: data copying.
212 PlainDataExcelConsumerEx. Export to Excel (xlsx).
214 PlainDataCubeConsumer. Consumer: repository cube.

See also:

Etl assembly enumeration