Introduction

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 and projects should be different in a production environment because production environments do not have SSDT installed in most cases. In this chapter, we will discuss and illustrate the different methods of executing a package and project.

In most cases, SSIS packages are executed on a scheduled basis, but there are some cases where an administrator or authorized user needs to run the package "on demand". SSIS packages can be...