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.