You can create and configure a Write transformation in the mapping editor.
You might want to use this method if you want to configure specific properties for the transformation. For example, you can create the transformation, and then configure it to define columns based on mapping flow and to get column metadata from the data source at run time.
Right-click in the mapping editor and select
Add Transformation
.
The
Add Transformation
dialog box opens.
Select
Write
and click
OK
.
The
New Write Transformation
wizard opens.
Select
Physical Data Object
or
Logical Data Object
, and then click
Browse
.
The
Select Data Object
dialog box opens.
Select a data source, click
OK
.
Select
Mapping flow
, and then click
Finish
.
Drag ports from the All Ports port of the upstream to the
Input
port of the Write transformation.
The following image shows how to connect upstream ports to the
Input
port of the Write transformation:
The Write transformation receives column definitions from upstream mapping objects.
To dynamically update target object columns at run time with changes from the target file, select
At run-time, get data object columns from data source
.
The Data Integration Service refreshes the column metadata for the Write transformation when the mapping runs.