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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
