Project Deployment Model: Project Deployment from SSDT
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.
Getting ready
Create an SSIS Catalog as follows:
Open SSMS from Start | Microsoft SQL Server | SQL Server Management Studio.
Connect to Database Engine (default instance like machine name or instance name such as
machine_name\instance_name).In the Object Explorer, expand the Integration Services Catalogs under the database server node. If there is no SSIS Catalog there, right-click...
