Post reply

Handover file import to user

  • August 19, 2016 at 12:47 am

    #329459

    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

    #1896296

    Which task you intend to hand over?

    _____________
    Code for TallyGenerator

  • August 19, 2016 at 2:02 am

    #1896300

    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

    #1896301

    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