Q: SSIS EXECUTE TASK not working as expected through sqlserver agent I have created a SSIS Execute Task package to export CSV and write into d:/ drive
It works when i execute from SSIS.However when i run from SQLServer agent, the job shows sucess but the export file is not available in the location
Can anyone please advise if anything i am missing.
Thank you

A: I think that the issue is that the SQL agent doesn't have access to the file system location. Make sure that SQL service account has needed permissions:


*

*Configure File System Permissions for Database Engine Access
