Options for Business Users to run SSIS packages RRS feed

  • Question

  • Currently our business users log into a server that has BIDS installed and run SSIS packages from there. What are the alternatives to prevent them from logging into server and running packages? Are there any better solutions?
    Saturday, January 18, 2020 7:50 PM

All replies

  • How about creating SQL Server jobs that will the run the SSIS packages. Users can open up SSMS in their local system and right click and run the job. This way, no need to remote login to server. 

    If the response helped, do "Mark as answer" and upvote it
    - Vaibhav

    Sunday, January 19, 2020 6:25 PM