O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Open SSMS from Start | Microsoft SQL Server | SQL Server Management Studio.
  2. Connect ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required