I have a ssis package(2008r2) in production server(file system) and multiple users have login's to production box.Currently the package is created using admin account 'john'.
Now I need a solution to give access to one of user to run the package.(note ms-sql is not installed with users logins) .I tried by creating proxy login to that user, but it failed to run the package.
Can anyone please give the best solution ,if possible a batch file for user to run the package instead of opening the package.?