Meta Data Service DTS Package

#1

Is there a way to change the owner of a Meta Data Service
DTS Package? I have an sp that can change a regular DTS
package owner but I can't find the DS DTS packages in the
mdsb database/sysdtspackages table. Anyone any ideas?

#2

Quote:

-----Original Message-----
In article <035a01c3717f$88d4ab50$a101280a (AT) phx (DOT) gbl>,
Linda
lleslie_ (AT) plls (DOT) com> writes
Is there a way to change the owner of a Meta Data Service
DTS Package? I have an sp that can change a regular DTS
package owner but I can't find the DS DTS packages in the
mdsb database/sysdtspackages table. Anyone any ideas?

Don't know. Why does it matter? I am familiar with
ownership within the
"local packages" arena and it is just a waste of space in
99% of cases.
Do you have a problem with ownership and Meta-Data
packages?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

.

Yes, someone wants to edit a Meta Data Services Package

that they did not create. This package is on the server
and was created by someone who no longer on the Data
Warehouse Team. The Data Warehouse Team has dbo rights
but not sysadmin.
Linda

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Meta Data Service DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Meta Data Service DTS Package - 09-02-2003 , 01:25 PM

Re: Meta Data Service DTS Package - 09-02-2003 , 04:03 PM