[thelist] DTS job permissions

Tab Alleman talleman at Lumpsum.com
Mon Nov 6 08:31:09 CST 2006


I'd go with the suggestion in the article.  Undocumented SP's are not to be feared.

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Brian Cummiskey
> Sent: Monday, November 06, 2006 4:30 AM
> To: thelist at lists.evolt.org
> Subject: [thelist] DTS job permissions
> 
> 
> Hi all,
> 
> (dealing with MS sql 2000)
> 
> 
> I have a DTS that is owned by me (\\domain\bcummiskey) but 
> the only way 
> to run jobs via the meta job task is through our admin account, 
> \\servername\administrator.
> 
> How can I change the package owner to that of administrator?
> 
> I googled and found this:
> http://www.thescripts.com/forum/thread78672.html
> 
> but that scares me, and I'm not sure if thats really what I 
> need to do.
> 
> Any suggestions?
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 



More information about the thelist mailing list