dtutil Examples

The following example copies an existing package in SQL to the SSIS package store:

C:> Dtutil /SQL ExistingPackage /COPY DTS;destPackage

The following example copies an existing package from one location on the filesystem to another location on the filesystem:

C:> dtutil /FILE c:\Unleashed\HotCustomersPlus.dtsx /COPY     FILE;c:\UnleashedProduction\HotCustomersPlus.dtsx

The following example creates a new GUID (usually after you copy a package):

C:> dtutil /I /FILE HotCustomersPlus.dtsx

The following example deletes a package stored in the local server (msdb database):

C:> dtutil /SQL HotCustomersPlus /SOURCEUSER ...

Get Microsoft SQL Server 2014 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.