How to deploy SSIS package from a Command Line Utility?

Problem: How to deploy SSIS package from a Command Line Utility?

Solution: dtutil Utility

In Some cases, you want to fix the package changes without deploying the entire project to the customer site, you may try to copy the package to the catalog folder. In this situation, you should move the package with the fix to copy by DTUTIL Command prompt utility.  

DTUTIL is good to script out the SSIS deployment and apply like one off on to a desired environment.

The dtutil command prompt utility is used to manage SQL Server Integration Services packages. The utility can copy, move, delete, or verify the existence of a package. These actions can be performed on any SSIS package that is stored in one of three locations: a Microsoft SQL Server database, the SSIS Package Store, and the file system. If the utility accesses a package that is stored in msdb, the command prompt may require a user name and a password. If the instance of SQL Server uses SQL Server Authentication, the command prompt requires both a user name and a password. If the user name is missing, dtutil tries to log on to SQL Server using Windows Authentication. The storage type of the package is identified by the /SQL, /FILE, and /DTS options.

Example:

In this article, I am going to show we can use DTUTIL to Copy the package from a file system to temp folder.

For example, we have a new version of a package to deploy to the Catalog.

Step 0: Go to the SSIS project and packages folder.  Open a command line window from there.

Copy to package store:

DTUTIL /FILE MergeLatest.dtsx /COPY DTS;MergeLatest

Copy to SQL Server

DTUTIL /FILE MergeLatest.dtsx /COPY SQL;MergeLatest

Copy to FileSystem

DTUTIL /FILE MergeLatest.dtsx /COPY FILE;C:\Temp\MergeLatest

 Copy to file system:

Results: