• All you need to do to change the package owner is set owner_sid and owner in msdb..sysdtspackages.

    If you get all the package IDs into a table then you can join to it and do the update in a single statement.

    MJ