How to remove locks on packages in distribution points list for a package

Sometimes you see lock on a DP for a particular package. This generally happens after a migration, or incorrectly creating a package.

To fix this, run the below query on your central database:

UPDATE Pkgservers set SourceSite = 'central site code' where PkgID = 'package id' and SiteCode = 'XXX'