Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Changing the Owner of a Single DTS Package

By SQLDev,

This is not an original script - but one I modified from an article by Darren Green on databasejournal.com (02/21/2000).  His original script changed the owner of all DTS packages owned by @old_owner to be owned by @new_owner. 

This script will change the owner of the most recent version of a specific DTS package (@p_name) to be owned by @new_owner.

The stored procedure should be placed in the msdb database and executed from that database.  Example command is:

EXEC sp_DTSReplaceOwner
@p_name = 'package name',
@new_owner = 'MyDomain\OwnerName'

Total article views: 489 | Views in the last 30 days: 1
 
Related Articles
FORUM

How to change Owner of a package

How to change Owner of a package

FORUM

how to find out dts package owner

how to find out dts package owner

FORUM

How can I change the owner of an SSIS Package?

How can I change the owner of an SSIS Package?

FORUM

scripting a database without db owner permissions

scripting a database without db owner permissions

BLOG

A Script A Day - Day 5 - Database Owner Permissions

Today's script will list all principals with membership in the db_owner fixed database role. /*...

 
Contribute