Export to a Database
Previous Top Next

With the Export Component you can export data from an in-memory dataset that was populated by a previous action like a SQL task directly to a database table.

graphic
  
Output Type
Select Database Table.
Use Connection
Specify the Database Connection to use with the Export.
Tables
Select the table to export the data to.
Fields
Select the fields to populate with the Include Checkbox and enter the value to populate into the table. To add a value from a dataset click on the field and use the Insert Expression button to select the correct field to populate the new field with.