Hi @scott Hanebutt ,
1.Please check if the DOMAIN\DomainAdmin has full permission to access to the file "Y:\FILE5945031821.txt".
2.May I know if you can create a text file on the "Y" drive manually?
3.Please Create a SQL Server Agent Proxy to use the user in design interface to execute ssis package.
A SQL Server Agent proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step.
Best regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.