-- Run this SELECT statement to obtain the package_id

select * from sysdtspackages where name = '<package_name>'

-- sp_reassign_dtspackageowner 'package_name', 'package_id' 'newlogin_name'

sp_reassign_dtspackageowner '<package_name>', '<package_id>', '<newLogin_name>'

Here's how we setup the proxy account:

1.The service account for SQLServer Agent must have the following user rights:

-Act as part of the Operating System

-Increase Quotas

-Log on as...