Question: how to import excel file to sql server using ssis?
Answer: Inside Data Flow, Drag OLEDB Destination from SSIS Toolbox. Connect our Source component to OLEDB Destination. Double click OLEDB Destination to configure it. Select Target Connection or click NEW to create new connection.