We need to change the Web Server location and will need to change the path location on all Distribution Packages.
Is there a supported way to achieve this?
Check out the document below. It's probably the true "supported" way.
Update Path for Multiple Distribution Packages
If you're feeling a little braver then you could look at doing it via SQL
How to update the file path on all of the SWD packages on a Core Server
Retrieving data ...