O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required