On the mapping canvas, click the Target transformation.
In the
Properties
panel, click
General
and enter a name for the Source transformation.
Click
Target
and select a flat file connection to write data to a flat file.
Select
Single Object
as the
Target Type
.
Select the flat file as the target object.
Select
Insert
as the
Operation
.
You can perform only the insert operation
In the
Field Mapping
tab, map the incoming fields to the target fields. You can manually map an incoming field to a target field or automatically map fields based on the field names.
Save and run the mapping.
After you validate the mapping, you can use the mapping to create a mapping task.