Source components deliver data for a transformation stream. A project typically starts with one or more source components. Source components have no IN-ports and at least one OUT-port.
Component |
Description |
|---|---|
Extracts data from any data source accessible by an ODBC connection or a native driver (DB2, Oracle, Sybase), or from Microsoft SQL Server via OLE DB. |
|
Performs incremental data loads. The incremental load is controlled by an ascending index attribute that contains the ascending values. |
|
Reads and transforms structured data from a text file into a table. |
|
Loads hierarchical XML data into a relational schema. |
|
Receives source table data changes from Replication Server, translates the data to the standard ETL data flow, and then sends the data to the next component. |
