For your goal you can use the following 4 approaches:
1. Linked server to Salesforce
If you want to configure a linked server to Salesforce, you can use Devart ODBC Driver for Salesforce.
To create a link from SSMS to Salesforce, you should configure our ODBC driver
https://www.devart.com/odbc/salesforce/docs/index.html on the computer with SQL Server (using DSN is required). Connect to the local server in SSMS, select Server Objects->Linked Server in the object tree, select New Linked Server in the shortcut menu, select Micosoft OLE DB Provider for ODBC Driver in the provider field, specify the created DSN in the Data Source field, specify any names in the Linked Serv and Product Name fields, click OK. If you haven't entered login and password in the DSN settings, you should specify them on the security tab (Remote Login With Password).
After this you can use dotConnect for SQL Server to query data from Salesforce objects as from any other linked server.
2. dotConnect for Salesforce and dotConnect for SQL Server
You can also use dotConnect Salesforce for reading data from Salesforce and then use dotConnect for SQL Server for write data to SQL Server.
3. Devart SSIS Data Flow Components for Salesforce.
You can use the SSIS Data Flow Components for Salesforce product for creating a SSIS package which will import data from Salesforce to SQL Server.
4. Devart Skyvia online tool.
If you want to import data from Salesforce to SQL Server you can use Skyvia - our cloud data integration, access, backup, and management platform. With it you can import data from and to various sources, including from SQL Server to Salesforce.
For more information about import packages in Skyvia, please refer to
https://skyvia.com/data-integration/import
https://skyvia.com/resources/docs/index.html?import.htm