November 29, 2005 at 11:24 am
I have a relatively simple DTS package that uses a text file from an FTP folder. The package runs fine when I execute but fails with the following message when scheduled.
Executed as user: HSC\SQLSERVICEMGR. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
I granted the SQLSERVICEMGR users rights to the FTP folder but the job still failed. Can anyone tell me what other user to try or tell me how to find out what user the scheduler is trying to use
November 29, 2005 at 12:10 pm
November 29, 2005 at 12:27 pm
A scheduled job runs under the SQL Agent user, not the SQL service.
Make sure the sevrice startup account for SQL Agent has the correct access.
November 29, 2005 at 1:01 pm
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply