I have the following problem.
I have some code which takes an input text file which is semi colon delimited. And converts it to SQL datatable.
The thing I want is to make this code as script so it will run every two hours.
The reason I want to do this is because the input text file will be updated every two hours. And I do not want to convert this txt to SQL manually. It should be automatic.
I have no idea how to achieve this? Is there a way I can create some script which will do this task ?
Open for any suggestions.
Hope I explained my question correctly.
Thank in advance