I got a CSV file on local file system (C:) which updates periodically with new data (it drops old data). I want to copy data from this file into a SharePoint list. I have solved this with a simple timer job which reads the file periodically and injects data into a predefined list, but I was thinking that Business Data Connectivity Service could solve this much more elegantly.
I am able to read from the file using a custom finder, but it only seems to rely on the data in the file, so if the CVS file is deleted all the data will also be deleted in SharePoint. There seems to be a cache, but this will also be dropped eventually.
