In Microsoft SQL Server 2005 Integration Services (SSIS), a 16-byte GUID is generated and stored as the PackageID property of a SSIS package when the SSIS package is created. After you run the package, you can write the package ID to a log file by using the SSIS log provider. This package ID differentiates log entries for different packages.
However, the following behavior may occur:
When an SSIS package is copied in a file system, the new copy contains the same package ID as the original SSIS package.
You can successfully run the package that has the same package ID. However, you cannot differentiate the two packages by using the logging data because the package IDs are the same.
To regenerate a new package ID for each package, use one of the methods that are described in the "More Information" section.
For example, the following conditions are true, in the order in which they are presented:
You copy a package that is named DuplicateIDEmailer to a file system.
You name the new package DuplicateIDEmailer_copy.
You run both packages.
You may notice that the logging data for each package is similar to the following:
The PackageName property that recorded in the Source column in the table was manually updated before execution. Therefore, some differentiation exists in the logging data. However, we recommend that you also regenerate the PackageID property.
To regenerate the PackageID property, use one of the following methods.
Use SQL Server Business Intelligence Development Studio
Open the package in SQL Server Business Intelligence Development Studio.
Click the Control Flow tab.
Click the ID property. In the drop-down list, click <Generate New ID>.
A new value appears in the ID property.
Use the dtutil command-line utility
You can use the dtutil command-line utility (Dtutil.exe) together with the /I [D Regenerate] command-line switch to regenerate the package ID. To update multiple packages at the same time, use the dtutil utility in a batch file or in the script environment. For more information about how to use the dtutil utility, type the following command at a command prompt:
To update the package IDs, put the packages in the same folder. Then, run the following command to regenerate the package ID for every package::
for %%f in (<FilePath>\*.dtsx) do dtutil.exe /i /File %%f
Note Use a single percent sign (%) when you type the command at a command prompt. Use two percent signs (%%) if you use the command in a batch file.
For more information about the dtutil utility, see the "dtutil utility" topic in Microsoft SQL Server 2005 Books Online.