August 19, 2016 at 12:47 am
Hi
I have created an excel template which is populated with forecast data by a few users.
Each month I get sent the file and import it into a table using a stored procedures (ssrs package currently being developed). Inevitably there are mistakes which means I have to run the tasks a few times each month.
Can anyone suggest a (simple) way in which I can hand over the task to either a single or multiple users?
We don't really use .net.
Thanks
August 19, 2016 at 1:27 am
Which task you intend to hand over?
_____________
Code for TallyGenerator
August 19, 2016 at 2:02 am
I'm hoping that they can save the file somewhere then run a job/tasks/process/file? that will import it into the db.
Thanks
August 19, 2016 at 2:10 am
Put all the users into a domain group. Give that group write access on the folder from which the file is imported. Change the job so that it detects when a new file arrives and does the import automatically. If changing the job isn't a possibility, create a stored procedure that runs the job and give the domain group access to run it.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply