Load CSV file into MS Sql Server Express Edition DB from a Dropbox Folder on Windows 7.
Basically, i need a script running on windows 7, picking up files from a dropbox folder and loading it into SQL Server Express Edition DB.
Data will be available daily in a dropbox folder. We can setup a windows scheduled task to run a process to execute windows script to load data.
I am not sure why type of parsing / re-formatting we may need. There maybe a number column that will need to be handled differelty. There is also a date / time stamp column that will need to be handled differently.
I will send you the sample files (at day level). You will test loading those using whatever type of script you feel is best to be able to do so.
I can share with you a dropbox folder where files will be.
One thing that needs to happen is that for each file in the dropbox folder, your script will process it and move it to a archive folder so it will not be processed again.
if you can generate an email notifiying me how many records where loaded, it will be great as well.
Again, this is Windows 7 env.