Question: how to import data from excel 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.