The Insert option allows you to add a new row of data into a database table whenever a triggered event occurs. You select the schema and table that is used as the target for this operation. The Input tab will consist of a collection of map variables whose values will be mapped to columns of that table. You can add the map variables automatically using the MapTable button (see Creating map variables automatically) or create each map variable individually (see Creating each map variable separately) .
When the trigger event occurs, a record is inserted into
the table. The map variable value will be used when
executing the SQL Insert operation at runtime. For more
information on how to build a transport map based on an
Insert operation, see
Your first transport map with a database transport.