by Reza Rad
In this chapter, we will cover the following topics:
SSIS packages and projects should be run on a machine that is usually called an SSIS server. In some scenarios companies decide to use the same database server as an SSIS server, and in some cases, companies decide to use a dedicated server as an SSIS server. Choosing between a dedicated SSIS server or using an existing database server as an SSIS server is a decision that requires the consideration of resource consumption for running SSIS packages, expected load, and availability of servers.
Running, or in the other words, the execution of SSIS packages ...