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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change owner of DTS package?

Status
Not open for further replies.
Danster

Danster

Technical User
May 14, 2003
148
AU
Gday all,

Is it possible to change the owner of a DTS package?

cheers

Danster
 
Sort by date Sort by votes
Give this a whirl. In Query Analyzer w/ the drop down database selection set for MSDB:

Code: 
sp_reassign_dtspackageowner [@name =] 'name',
[@id =] 'id',
[@newloginname =] 'newloginname'

You may even be able to disreguard the @id value from the query

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JoPaBC
  • Locked
  • Question
Schedule and automate backups of SQL Express databases in SQL Server Express 1
Replies
5
Views
752
JoPaBC
JoPaBC
lavadan
  • Locked
  • Question
current max value of all int columns
Replies
1
Views
251
fredericofonseca
fredericofonseca
tekpr00
  • Locked
  • Question
Capture and Replicate Changes from Source to Target.
Replies
0
Views
226
tekpr00
tekpr00
Craig_DaviesB2
  • Locked
  • Question
Migration of SQL 2008 R2 Standard to SQL 2012 Standard - @flags parameter not valid SSIS
Replies
1
Views
318
simian336
simian336
TheBugSlayer
  • Locked
  • Question
Backu and restore of multiple filegroups
Replies
2
Views
277
TheBugSlayer
TheBugSlayer

Part and Inventory Search

Sponsor

Back
Top