SQL SERVER bulk insert issue

SSIS and Import/Export
1

Hi mates,
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:

BULK INSERT
#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.

2

Are you sure the file is available with updated data when you think it is and that the SP is completing on that data?
Doing this sort of thing every 5 seconds is a bit odd.
I'm guessing you must be using a file rename to get round locking issues? Are you sure that is completing?