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.