RE: DTS Error

Tech-Archive recommends: Fix windows errors by optimizing your registry

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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:3049D439-D961-4450-82C2-9E953E82CA9A@xxxxxxxxxxxxx:
>
> > 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
>
>
.

Relevant Pages

  • RE: DTS Package fails when Scheduled
    ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Re: Problems with SQL Srv. Agent and Proxy Account
    ... I have tried with both the sa account and with Use Windows ... Authentication on the SQL Server AGent Connection tab. ... >>rights recording to INF: Reset Proxy and the ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... -Web Application is using Basic Authentication set in IIS ... -Added user account TESTUSER and gave read access to ... in SQL server but doesn't work if user account was ... Windows account, ...
    (microsoft.public.sqlserver.security)
  • Re: cant find directory when package scheduled as job
    ... the batch file to map the drive. ... from the DTS designer but fails when it is scheduled as a SQL Server Agent ... under my windows account and the packages executes correctly when run via ...
    (microsoft.public.sqlserver.dts)
  • Re: Problems with SQL Srv. Agent and Proxy Account
    ... You need to go to the General Tab of the SQL Server Agent ... >I have tried with both the sa account and with Use Windows ...
    (microsoft.public.sqlserver.security)