sql-serverssisenterprisesql-server-data-toolsssdt-bi

Run SSIS/SSDT on app server


My company is insisting that we not run SSIS/SSDT jobs on the DB server, but instead run them on an app server and since they're not offering any assistance how this possible I'm trying come up with ways to do it. Here are my ideas so far, but would like to know of any approaches tried that work.

Ideas?


Solution

  • If they want them to run on the app server then they will need to buy a SQL license for it.

    Start there and see if they will run them on the db server!