Question: how to import data from sharepoint list to sql server using ssis?
Answer: Make sure to use the latest version of SQL Server Data Tools to work with SQL Server integration Projects. Use the Data Flow Task. You can see “OData Source” task. ...  This OData Source task required a connection manager. ...  Test the connection. On the OData Source Editor, Choose the SharePoint list on the collection section.