To choose a Single Table transform, the radio button must be selected that says, "Use single table for existing transform". A drop down list box will be displayed under the Select Source Table caption. This list will contain all of the potential tables that included in the CONNX Data Dictionary File. The user must select a single table which will serve as the input for the target destination file.
One valid reason to choose this transform is for transforms that might only include certain fields of an existing table. It can also be used to map derived columns (e.g. orderamt * 100). When choosing this transform, SQL is not required unless a derived field is created, and requires SQL to create a transformation from source column(s).
By pressing the next button, the next step in the wizard is Assigning a Destination.