Import CSV updates to SQL Server

Question

I am looking for a simple solution (from beginner to SQL) that allows me to import data from my CSV file into my SQL database.

I have a third-party program that updates my CSV file every 30 seconds, and I want to put this update information into my SQL database. I tried the import and export wizard, but it did not work due to the fact that the CSV file was used by another third-party program.

Retrieving information in an SQL database is not necessary in real time, it can simply get all the information when opening a saved sql query file.

Thanks!

Answer 1

OPENROWSET , , env CSV . MS- ​​ 32- 64- .

, SSIS CSV . SSIS SQL JOB . , /, .

Answer 2

-, , .

, - , , /. / concurrency, , , .

- .

, , - . - , , .

, .

CSV , / .

, CSV SQL Server

http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/