"Travis" <Travis@discussions.microsoft.com> wrote in message
news:7806AFB9-A005-41F4-91C0-A3C6CD730368@microsoft.com:

> Hi Allan ,
>
> I right click on the SQL Server Agent properties , the "Services" was
> startup using
> Windows Account and the "Connection" also under Windows Account.
>
> When I execute the Jobs , the error msg was "Access Denied" ... my DTS
> was read from the csv file in "Share Folder" on server local hard disk.
>
> The job owner I set using "sa" which is SQL Admin .... anything wrong
> with that ?
>
> How do I set the runner as 'sa' ?
>
>
> --
> Travis Tan
>
>
> "Allan Mitchell" wrote:
>
>
> > So the creator of the package has no relevance here. What does is the
> > account under which the job runs.
> >
> > Any member of the sysadmin role and the job executes as the SQL Server
> > Agent Service Account
> > If the "runner" is not a member of the sysadmin role then the job is
> > executed as the proxy account.
> >
> > Allan
> >
> > "Travis" <Travis@discussions.microsoft.com> wrote in message
> > news:3049D439-D961-4450-82C2-9E953E82CA9A@microsoft.com:
> >
>
> > > Hi Allan ,
> > >
> > > I am not sure what is wrong here. I create a package under 'sa'
> > > and I scheduled under 'sa' but when I check the windows event log
> > > the scheduled is run on domain user ...
> > >
> > > Where can I change the setting ? Please advice
> > >
> > > --
> > > Travis Tan
> > >
> > >
> > > "Travis" wrote:
> > >
> > >
>
> > > > Hi ,
> > > >
> > > > I created a DTS package and it running fine when I run in
> design
>
> > > view.
>
> > > > But when I scheduled it , it fail to run and I get this kind of
> error
>
> > > ,
>
> > > >
> > > > "Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
> > > > Step Execution Started: 9/21/2005 10:45:53 AM
> > > > Step Execution Completed: 9/21/2005 10:45:53 AM
> > > > Total Step Execution Time: 0.063 seconds
> > > > Progress count in Step: 0
> > > >
> > > > Step 'DTSStep_DTSDataPumpTask_1' failed
> > > >
> > > > Step Error Source: Microsoft Data Transformation Services Flat
> File
>
> > > Rowset
>
> > > >
> > > > Provider
> > > >
> > > > Step Error Description:Error opening datafile: Access is
> denied. "
> > > >
> > > > I suspect is the security issue but I am not sure where can I
> debug
>
> > > it.
>
> > > > - The package was created under user "sa" - SQL Server Admin
> > > > - The package was scheduled under user "sa" - SQL Server Admin
> > > >
> > > > - The DTS package will extract the data from a csv file from a
>
> > > "Share
>
> > > > Folder"
> > > > - The "Share Folder" was restricted to only certain users
> > > >
> > > > Please advise.
> > > >
> > > > One more issue , how to I show the "Step Name" in my error log
>
> > > instead of
>
> > > > showing the "DTSStep_DTSDataPumpTask_1" ?
> > > >
> > > > Travis Tan
> >
>
> >