Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change Ownership of DTS Package

Status
Not open for further replies.
Waynest

Waynest

Programmer
Jun 22, 2000
321
GB
Hello

SQL Server 7

We have a couple of local DTS packages belonging to a chap who has left the company. I can't seem to find where you change the owner of the package?

Thanks
Wayne
 
Sort by date Sort by votes
They are stored in the sysdtspackages table in the msdb database. Column is owner:

Code: 
USE msdb
GO

UPDATE sysdtspackages
SET owner = '<new owner>'
WHERE name = '<package name>'
--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
146
tekpr00
tekpr00
arodri
  • Locked
  • Question
MSVisual Studio - DTSX Package creating new text file
Replies
0
Views
145
arodri
arodri
Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
150
Fsoumia
Fsoumia
HoustonGuy
  • Locked
  • Question
CPU usage of a package using tables on another server
Replies
0
Views
56
HoustonGuy
HoustonGuy
ashleybyrdnc
  • Locked
  • Question
DTS Package Failing
Replies
1
Views
81
mrdenny
mrdenny

Part and Inventory Search

Sponsor

Back
Top