Excel

The Excel connector is an object that is used to export data to Microsoft Excel files (*.xls or *.xlsx).

After adding the connector to the ETL task workspace, set basic properties and export options. The connector input and output can be also edited, and error handling parameters can also be set.

Export Options

The Export Options page is used to specify a file for data export.

Export to the XLS file

Export to the XLSX file

See also:

Data Consumers