Microsoft SQL Server 2014 Unleashed

dtutil Examples

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

Click here to view code image

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:

Click here to view code image

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):

Click here to view code image

C:> dtutil /I /FILE HotCustomersPlus.dtsx

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

Click here to view code image

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