- Jan 21, 2005
- 17,722
- 6
- 81
I scheduled one of my DTS packages that is generating a flat file. Runs great when I execute it manually, but for some reason, SQL Server Agent can't run my job. And supposedly it has access to the share I am writing to.
Here is the error I got:
What gives?
Here is the error I got:
Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Step Error Description:Error opening datafile: Access is denied.
Step Error code: 80004005
Step Error Help FileTSFFile.hlp
Step Error Help Context ID:0
What gives?