SSDT is not a tool only for SSIS Package Development, but also for deployment of packages. There are two types of deployment models in SSIS 2012. In this recipe, we will take a look at Project Deployment Model with SSDT and in the fourth recipe of this chapter we will take a look at Package Deployment Model.
To use Project Deployment Model, we need an SSIS Catalog. SSIS Catalog is a repository for SSIS projects, which also manages their versioning and parameters. We will take a look at how to execute packages and get reports from SSIS Catalog in the next chapters.
Create an SSIS Catalog as follows: