Hi All,
We are using windows authentication to login to SQL Server, when I
create DTS packages it shows my userid as the owner, I want dbo to be the
owner of the package. I know we can use dbo.XXX for other objects
(procedures/tables) to make dbo the owner, but don't know how to for DTS, I
need help in this if someone can answer my question please help.


Thank you
Sincerely,
Developer One

This may help you although I don't know that dbo will ever be able to own them

Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"SQLServer Dev" <SQLServerDev (AT) discussions (DOT) microsoft.com> wrote