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

Using Integration Services Deployment Wizard and command-line utility for deployment

The deployment of a project from SSDT is very easy but not very common, because it needs SSDT to be installed somewhere. It is very common that SSIS projects are developed under a development machine in the company but the production environment is in another workplace or network, so SSDT can't be used in these situations. We need to deploy the project without having SSDT.

There are two ways to deploy a project in Project Deployment Model: one of them is through SSDT, which was described in the previous recipe. Another way is to use the Integration Services Deployment Wizard to deploy the project from ISPAC files; we will deploy the same project from the previous ...

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