We manage some SSIS servers, which has only SSIS and SSIS tools installed on them and not the sql server DB.

SSIS packages and configuration files are deployed on a NAS. We run the SSIS packages through DTEXEC by logging in to the server.

We want to allow developers to run their packages on their own on the server, but at the same time we dont want to give them physical access on the server i.e we do not want to add them into RDP users list on server properties. We want them to allow running their packages remotely on the server.

One way We could think of is by using powershell remoting and we are working on that. But is there any other way or any tool already present for the

We want to allow developers to run their packages on their own on the server,

Will these developers be on the same domain? Also will their machines be having SQL Management studio?

ALso see

https://msdn.microsoft.com/en-us/library/ms403348.aspx

There's also a similar thread here

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a636dd43-daf3-489a-9696-848d1f72304c/runing-package-on-a-distant-server-using-dtexecexe

This specifies the powershell option also

Hi ,

You can give permission to directory only .
Then using Batch file they can execute the package.

1. Give persmission to derectory .
2. Create Batch file on Directory to execute SSIS Package using DTEXec command
3. USer can access this directory and execute that file

You can also use Powershell and stored procedure option to execute SSIS Package
http://www.databasejournal.com/features/mssql/executing-a-ssis-package-from-stored-procedure-in-sql-server.html
Thanks

In my opinion, invoking Batch file locally to execute the SSIS packages (On developer machine) will not serve the purpose since it will look for SSIS service on the local machine and the chances are quite less that you would have it (Since it has to be licensed)

The best would be to create the Powershell script, set-up the credentials to connect to SSIS server (Known as Remoting) and make the call to execute the DTEXEC command or batch-file. We have done something similar in the past and that should work for you.

The only thing you have to take care of is setting-up credential to connect to the server (Using some domain account) as well as execute permission to run PS on the Target (SSIS) Server

HTH