I have a package in MS SQL 2000 that was created by an Active Directory account that was deleted. The scheduled job that invoked the package failed after the Acive Directory login was deleted. The owner was changed to a valid Active Directory account using the code below before the Active Directory account was deleted. The scheduled job was not owned by the deleted Active Directory account
--// Everything checks out, so reassign the owner.
--// Note that @newloginname may be a sql server login rather than a network user,
--// which is not quite the same as when a package is created.
SET owner_sid = SUSER_SID(@newloginname),
owner = @newloginname
WHERE id = @id
RETURN 0 -- SUCCESS
Also we have noticed that everytime we go in and make a change to a package and save the creator become the owner again.
Anybody have these issues? Is the problem that the creator of the package is a deleted Active Directory login? How can I change the creator?
Thanx for your time,