Welcome to Julian Kuiters Friday, July 20 2018 @ 04:35 PM AEST

Generating a new SSIS Package GUID with the dtutil Utitlity

  • Contributed by:
Integration Services 2005 / SSIS (DTS)

If you make a copy of a .dtsx file, the Package ID property remains the same. This value is logged as the SourceID, and to ensure it is unique, you should generate a new value for any copies of a package.

dtutil /FILE "Copy of sample.dtsx" /IDRegenerate

Or the short hand version

dtutil /FILE "Copy of sample.dtsx" /I