The Owner or Creator of a DTS package has been the cause of much concern, there is a BIG issue that can cause problems for non-system administrators.
If you are not the owner and not a member of the sysadmin role the following error will be returned saving or deleting a package: "Only the owner of DTS Package 'MyPackage' or a member of the sysadmin role may create new versions of it."
The solution is to use the undocumented stored procedure sp_reassign_dtspackageowner.
- Open Query Analyzer
- Select MSDB database
- Get the package Name/ID with the query: SELECT DISTINCT [name], [id] FROM sysdtspackages
- Run the following query after setting the correct package Name/ID: exec sp_reassign_dtspackageowner @name='My Package', @id='B3DA332F-48A9-4E6B-AEAE-058EA4E2793C', @newloginname='NewOwner'