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

DTUTIL—the command-line utility for deployment

Package Deployment Model is based on packages and this means that every package should be deployed independently, but Deployment Utility can help to create one setup kit for all packages. Deployment Utility is helpful but it needs a user who is familiar with SSIS to choose destination type, set server properties, and other things which were in Package Installation Wizard. There should be a method to deploy everything without interaction with the user in silent mode.

Fortunately, SSIS provides a command-line utility—DTUTIL.exe—for Package Deployment Model. We can write statements on DTUTIL to deploy packages in silent mode.

In this recipe, we take a look at how to deploy packages with DTUTIL.

How to do ...

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