In a previous post I discussed how to create and use SSIS templates. One issue that can arise when doing this is that duplicated GUIDs will be assigned to each copied package. This creates identification issues if you utilize SSIS logging.
There are three simple solutions to solve this problem:
1. Manually select the generate new GUID option in the ID drop down box in your package properties.
2. Right click the package name and choose the option to reset all GUIDs within the project. This requires the BIDS Helper add on.
3. Rename your package and a new GUID will be automatically generated.
2 thoughts on “GUID Fix When Copying and Pasting SSIS Packages”
My brother suggested I might like this website. He was entirely
right. This post actually made my day. You can not imagine just how much time
I had spent for this information! Thanks!
You’re very welcome, glad I could help! Message me any time with other questions you have. 🙂