We need a query that automaticly (e.g. every day at 4pm) imports data from a [url removed, login to view] in our db (ms sql) with:
> fieldterminator ";" and
> rowterminator "\n"
If the row exists in table then not overwrite
If its an new flatfile then make an empty row
> After import is done, rename [url removed, login to view] in [url removed, login to view] or move the file into a subfolder
Thats in short. Is this possible?
24 freelancers are bidding on average €67 for this job
I can do a windows service to run in the background and watchs the folder , so it can import the data from the new flat file into the DB, then move it to another folder or subfolder it will be configurable.