I have a windows service running each 5 seconds and this service just call a store procedure in a SQL Server Database, this store execute a bulk insert like:
#temp_table FROM '\path_to_csv.csv'
WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '0x0a', KEEPNULLS, TABLOCK );
I realize that the temp table gets outdated values instead of getting fresh values of the CSV file. Any help is welcome.