• I prefer to have the ETL (SSIS) installed on a different server because it is quite common to need to install or update additional software, controls, DLLS, etc. that might need a reboot, or that might experience a problem that will require a reboot.

    Also, you might need to have the ETL (SSIS) on a different version of SQL Server than the main database server.