How to change owner of DTS Package [ All Languages » SQL Server »  DTS] Total Hit ( 2812) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

Here is an example to change ownership of a DTS Package of SQL Server. You can use undocumented stored procedure msdb.dbo.sp_reassign_dtspackageowner to change ownership. This stored proc requires 3 parameters. First parameter is @name which is name of package. Second parameter is @id which unique ID of the package since package name is ot guranteed so we have to supply package unique ID. Third and last parameter is new owner login name. First of all you need to find Package GUID which will be @id parameter of sp_reassign_dtspackageowner. You can find that using the following simple Query. Click here to copy the following block Select id from msdb.dbo.sysdtspackages where name = 'pkgTest1' go Now pass the package name, GUID which you got from previous query and new owner login name Click here to copy the following block Exec msdb.dbo.sp_reassign_dtspackageowner    @name = 'pkgTest1',    @id = '7CF0880F-7EC0-443B-87D7-E87AC240E17C',    @newloginname = 'NewOwner'

Related Article(s)

Import all files in a directory using DTS (Multi Pkg)

Where can I find more DTS information and samples?

How can I ensure that my scheduled DTS Packages will execute correctly?

SQL Server 2000 DTS Part 10 - DTS Designer Tasks - The Data Driven Query Task

DTS Servers and Schedulers for MS SQL

SQL Server 2000 DTS Part 9 - DTS Designer Tasks

SQL Server 2000 DTS Part 8 - DTS Designer Tasks - Transform Data Task

SQL Server 2000 DTS Part 7 - DTS Designer Tasks: the ActiveX Script task

SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow

SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables

SQL Server 2000 DTS Part 4 - DTS Designer Tasks

SQL Server 2000 DTS Part 3 - DTS Designer Connections

SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards

Updating SQL Server Connection Properties from the DTS Package INI File

How to Do SQL Server Performance Trend Analysis Part 2: Storing Performance Data in SQL Server

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )