Introduction

Till now you have read many chapters on the development of packages; this chapter focuses on another phase of ETL or data transfer implementation, which is deployment. Every package and project that we created in the previous chapters works correctly on SSDT. However, note that a production environment probably doesn't have SSDT installed, so we should deploy our packages to production on the SSIS server.

The SSIS packages and projects are saved on the local machine at the time of development. If we want to use them in the production environment, we need to save them in other locations considering the parameters. This process called deployment. There are two deployment models for SSIS packages. Project Deployment Model, which is a new model of deployment presented by SSIS 2012. Project Deployment works with SSIS Catalog. In this chapter, we will see how to deploy projects in this model using the SSIS Catalog.

The other deployment model, which is Package Deployment Model, has been...