Select the source object for the Source transformation on the
Source
tab of the Properties panel.
The properties that you configure for the source object vary based on the connection type and the mapping type.
The following image shows the
Source
tab for a relational source:
Source details where you configure the source connection, source type, and source object.
You can select a source in the following ways:
Select the connection and source object.
In the
Details
area, select the source connection, source type, and source object. For some source types, you can select multiple source objects. You can also create a new connection.
The source type varies based on the connection type. For example, for relational sources you can select a single object, multiple related objects, or an SQL query. For flat file sources, you can select a single object, file list, or file list command.
Use a parameter.
You can use input parameters to define the source connection and source object when you run the mapping task. For more information about parameters, see