DTS Package owner change:
sp_reassign_dtspackageowner 'Package_name’, ‘Package_id’, 'Newownerloginname’ |
Parameters descriptive:
Package_name ->specify name of the package.
Package_id ->get the id value from below output for the corresponding packages.
use msdb
GO
select * from sysdtspackages
Moreover we can take idvalue for the latest ‘created date’ column from the above table.
No comments:
Post a Comment