Scheduling a DTS package without admin privileges.

I have created a dts package that I can execute from within sql server
enterprise manager. However, I don’t have admin privileges so when I
schedule a job within sql server it fails to execute because I don’t have
the
necessary privileges.
Since I have the privileges to run the DTS package I have created I am
interested in another means of scheduling my DTS package. I was thinking of
making use of the windows task scheduler or if that is not possible making a
windows service.
Right now I am using the dtsrun.exe but I can only use this if sql
server is installed on the machine that requests the DTS package to be
executed. I was hoping to find a way to request the DTS Package to be run
from any machine of my choosing. I got excited when I found the DTS com dl
l
but it appears only to provide a wrapper that communicates with the locally
installed sqlserver. Is there another way to do this other than have admin
privileges and keep it on the actually server? For now I have created a dts
substitute…Basically I have every thing I need to do in a series of stored
procedures and I call that from a windows task scheduler. (However I am
missing email and other capabilities.) Do I really need admin privileges to
be able to schedule a DTS package?Hello,
The security context in which the DTS job is run is determined by the owner
of the job. If the job is owned by a login that is not a member of the
Symin server role, then the package is run under the context of the
account setup as the SQL Agent Proxy Account, and has the rights and
permissions of that account.
For SQL Agent Proxy to be able to run jobs that connect to SQL Server, the
SQL Agent Proxy account must have proper Windows/NT permissions and be
granted login access to SQL Server with appropriate database permissions.
For the jobs that execute a DTS package, the SQL Agent Proxy Account must
have read and write permissions to the temp directory of the Account the
SQL Server Agent is running under. For example,
c:\Documents and Settings\<Account>\Local Settings\Temp
You may want to look at the following article:
http://support.microsoft.com/defaul...kb;en-us;269074
also the security discussions at:
http://support.microsoft.com/defaul...kb;en-us;252987
http://support.microsoft.com/defaul...kb;en-us;322746
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Scheduling a DTS package without admin privileges.
>thread-index: AcZD0ZYb2apHTm+GQoGmib/7CppZqQ==
>X-WBNR-Posting-Host: 66.162.65.194
>From: examnotes <JeffDotNet@.newsgroups.nospam>
>Subject: Scheduling a DTS package without admin privileges.
>Date: Thu, 9 Mar 2006 15:31:27 -0800
>Lines: 20
>Message-ID: <2AB4DFE2-6F42-4DD5-8AAF-339819986F39@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 8bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>Newsgroups: microsoft.public.sqlserver.programming
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.programming:586021
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.programming
>I have created a dts package that I can execute from within sql server
>enterprise manager. However, I don’t have admin privileges so when I
>schedule a job within sql server it fails to execute because I don’t
have the
>necessary privileges.
> Since I have the privileges to run the DTS package I have created I am
>interested in another means of scheduling my DTS package. I was thinking
of
>making use of the windows task scheduler or if that is not possible making
a
>windows service.
> Right now I am using the dtsrun.exe but I can only use this if sql
>server is installed on the machine that requests the DTS package to be
>executed. I was hoping to find a way to request the DTS Package to be run
>from any machine of my choosing. I got excited when I found the DTS com
dll
>but it appears only to provide a wrapper that communicates with the
locally
>installed sqlserver. Is there another way to do this other than have
admin
>privileges and keep it on the actually server? For now I have created a
dts
>substitute…Basically I have every thing I need to do in a series of
stored
>procedures and I call that from a windows task scheduler. (However I am
>missing email and other capabilities.) Do I really need admin privileges
to
>be able to schedule a DTS package?
>