Problem
In earlier builds than the September 2023, a registry management issue was discovered: certain registry keys created during SSIS package execution were not always removed. Over time, this behavior can result in leftover entries in the Windows registry, leading to registry bloat in environments that run frequent ETL jobs.
Why does this problem occur?
This is a bug in earlier versions of the SSIS Powerpack created before September 2023.
You could get this error message:
Msg 123456, Level 16, State 2, Line 0
Connection error, please check any other application uses port 50433 -OR- check if port is in the reserved range (NAT Service).
When running a package using Zappysys SSIS components:
-
New registry keys were created under:
HKEY_CURRENT_USER\.DEFAULT\SOFTWARE\Classes\CLSID -
Keys were created and deleted in an imbalanced ratio, leaving behind orphaned entries.
-
Over time, these orphaned keys accumulated, causing registry bloat and making registry management more complex.
Solution
Install the latest SSIS PowerPack version.
The registry cleanup issue was fixed in Version 5.3.1.10901 [Sep 20, 2023] and newer versions.
- Download and install the latest version of ZappySys SSIS PowerPack from the official site.
- Review the release notes to confirm the fix.
- Upgrade the tool on all affected servers and environments.
- After updating, SSIS PowerPack will correctly clean up registry entries created during package execution.
- Tip: If the SSIS service account lacks write access to HKEY_CLASSES_ROOT, configure permissions correctly. Limited permissions were one of the causes of orphaned entries.
Verify the Resolution
- Execute a package using updated SSIS PowerPack components.
- Inspect the registry path to confirm that leftover keys are no longer being created.
- Clean up any legacy orphaned entries safely if they remain from older builds.
Conclusion
Earlier builds of ZappySys SSIS PowerPack had a registry management bug that could result in orphaned registry keys. This issue has been resolved in Version 5.3.1.10901. If you are experiencing registry bloat on SSIS servers, upgrade to the latest version to benefit from this fix and ensure smoother, more efficient ETL operations.
Explore our SSIS PowerPack for more information and download and install it to start building smarter, faster, and more scalable solutions.
References
Contact us
If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.