Question: how to export data from sql server to excel in ssis?
Answer: STEP 1: Drag and Drop the Data Flow Task from the toolbox to the control flow region. ... 
STEP 3: Double click on OLE DB Source to configure the SQL Server connection manager and also to select the required data from the table.
STEP 5: Let us configure the destination by double-clicking the Excel file destination.