Use the Connection Manager page of the Excel Destination Editor dialog box to specify data source information, and to preview the results. The Excel destination loads data into a worksheet or a named range in a Microsoft Excel workbook.
The CommandTimeout property of the Excel destination is not available in the Excel Destination Editor, but can be set by using the Advanced Editor. In addition, certain Fast Load options are available only in the Advanced Editor. For more information on these properties, see the Excel Destination section of Destination Custom Properties.