If I have a SSIS Package created in VS 2005 and asked to install and setup this package. Does the server that is going to run this SSIS package have to have SSIS installed? I am 99% sure this is yes, since when I run dtexec /DT packagepath it advises this server does not have SSIS service to run this. Is this correct?
If so, is it best to have one SSIS server to run all packages or install SSIS on the servers that are going to have SSIS packages ran from them?