Change Owner of Packages

[AshleyRickards]

I need to change the owner of packages from myself to another. Thanks! Ashley L Rickards
SQL DBA

 

[tlbroadbent]

Hi Ashley,

Check this link...

http://www.sqldts.com/main.asp?nav=1,6,212,0

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[AshleyRickards]

Thanks Terry .. where would I find the package ID. I've looked in sysobjects in master and model? Ashley L Rickards
SQL DBA

 

[tlbroadbent]

Packages are stored in msdb - sysdtspackages table.

Other tables used for package info:
sysdtscategories
sysdtspackagelog
sysdtssteplog
sysdtstasklog Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[AshleyRickards]

Thanks again .. I'll work with this. Ashley L Rickards
SQL DBA