> Dear all experts,
>
> I have googling already, but still cannot found out the solution.
>
> I have packed a DTS, which will read Excel from a domain server, and set
> the schedule, if I running the DTS manually through the Enterprise
> Manager, I can run successfully. However, the scheduled work is failed
> because of following message
>
> Executed as user: N1\SYSTEM. ...Run OnStart: Create Table
> [mf_slx].[dbo].[DataExhibitor] Step DTSRun OnFinish: Create Table
> [mf_slx].[dbo].[DataExhibitor] Step DTSRun OnStart: Copy Data from
> DataExhibitorUI$ to [mf_slx].[dbo].[DataExhibitor] Step DTSRun OnError:
> Copy Data from DataExhibitorUI$ to [mf_slx].[dbo].[DataExhibitor] Step,
> Error = -2147467259 (80004005) Error string: The Microsoft Jet
> database engine cannot open the file
> '\\202.177.19.197\d$\clients2\DataExhibitor.XLS'. It is already opened
> exclusively by another user, or you need permission to view its data.
> Error source: Microsoft JET Database Engine Help file: Help
> context: 5003051 Error Detail Records: Error: -2147467259
> (80004005); Provider Error: -534709256 (E020FBF8) Error string: The
> Microsoft Jet database engine cannot open the file
> '\\202.177.19.197\d$\clients2\DataExhibitor.XLS'. It is already opened
> exclusively by another user, or you need... Process Exit Code 1. The
> step failed.
>
> I tried to set the ownership of the schedule to the domain administrator,
> but not local administrator, but it still using local system account to
> run the schedule. I searched that I maybe need to change the account,
> which start the SQL Server Agent, to others, is it real? If so, how can I
> change the running account from current to another?
>
> Thanks
>
> Wing Siu
>