We have several jobs that run DTS packages. Yesterday our IT department
changed all users network IDs. The owner of the jobs was able to change the
ownership of the jobs to his new ID but it doesn't look like he did on the
DTS packages. All of the jobs failed because of this.

Is there a way to change the ownership of DTS packages?

Have a look here

Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)


By the way. What was the error? Are you sure it wasn't the Agent Service
Account or the Proxy Account being bumped?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"LeAnn" <LeAnn (AT) discussions (DOT) microsoft.com> wrote