Export to a File
 Previous Top Next
With the Export Data Component you can export data from an in-memory dataset that was populated by a previous action like the SQL Task directly to a file in CSV, tab or character delimited and fixed field length formats.

graphic
  
Output Type
Select Text or CSV File.
File Name
Enter the path where the file will be created.
Delimited
Select this option if the fields are delimited.
Fixed Length
Select this option if the fields are fixed length.
Field Delimiter
Specify the delimiter to use between the fields.
Write Column Header
Check this option if you want to write the headers out to the file.
Field Definitions
Specify the column names, length, optional padding options and the value to export. To export a value from another dataset place the cursor inside the field value and use the Insert Expression button to select the correct dataset field to use.