DST schedule job failed.
I logged on as SA to create a DTS package to create an Excel file on a network drive and import the query result to that Excel file. When I tried to run the DTS, it ran thru all. When I created a job to schedule the DTS, it was failed. I had the following errors:
Executed as user: DSHS\hrdadmin. ...OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft Excel Error Description: Microsoft Excel cannot access the file '\\dshsasdfps1\Shareroot\home\buibt\ASDExcel'. There are several possible reasons: The file name or path name does not exist. The file you're trying to open is being used by another program. Close the document in the other program, and try again. The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook with a different name. Error on Line 44 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error... Process Exit Code 1. The step failed.