Change DTS Package Owner

Question

Post reply

Change DTS Package Owner

gfahrlander

SSCommitted

Points: 1888
More actions
January 13, 2004 at 1:04 pm

#59063

How can I change the owner of a DTS Package?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736455 More actions · Answer 1

Steve Jones - SSC Editor

SSC Guru

Points: 736455

January 13, 2004 at 1:44 pm

#489850

Open, save under a different name.

gfahrlander SSCommitted Points: 1888 More actions · Answer 2

That won't change the owner, just the package name. I need to assign a production support person to ownership so they can work on the package. We're using windows authentication.

gfahrlander SSCommitted Points: 1888 More actions · Answer 3

The undocumented msdb stored procedure:

sp_reassign_dtspackageowner

chubbsm SSCommitted Points: 1770 More actions · Answer 4

Go out to http://www.sqldts.com/ you will find all the info you need to accomplish this!