DTS package execute fine manually, but as job I get...

I created a DTS package that simply select values from a table and exports them to a .txt file.

The package runs just fine if I execute the package manually.

However, when i set it up as a schedule job, the job fails;  the job log details are as follows...

The job failed.  The Job was invoked by Schedule 71 (Horizon --> Midas \ sis$).  The last step to run was step 1 (Horizon --> Midas \ sis$).

Executed as user: TENEX\SYSTEM. DTSRun:  Loading...   DTSRun:  Executing...   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.
LVL 9
tl121000Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
SRigneyConnect With a Mentor Commented:
The error you provided shows that in step DTSStep_DTSDataPumpTask_1.   There is an error "Error opening datafile: Access is denied."  

Try logging in as the user that the package is running as when it's a job and run it manually.   Otherwise, double check the files that are used in that step and verify that the user has permissions to the server/folder/file to do what needs to be done.
0
 
SRigneyCommented:
You are getting the error.  Error opening datafile: Access is denied.     Most likely the user that the job is running as does not have permissions to something that you have permissions to.
0
 
tl121000Author Commented:
the owner of the job is the domain admin - the job is being run as the domain admin manually - any thoughts?
0
 
tl121000Author Commented:
delted and recreated the dts task using the sql account for db connectivity and the domain admin as job owner...

It was set up this way previously - no matter it works now

Thanks,
Tim
0
All Courses

From novice to tech pro — start learning today.