SQL Server 2017
I have created an SSIS package that creates a text file on the "Y" drive which is mapped to another server. When I run the package through the design interface it correctly creates the file. However when I have a SQL job run the package I get the following error.
Executed as user: DOMAIN\DomainAdmin. Microsoft (R) SQL Server Execute Package Utility Version 14.0.1000.169 for 64-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 9:28:43 PM Error: 2021-03-18 21:28:44.93 Code: 0xC020200E Source: Data Flow Task 1 Flat File Destination [2] Description: Cannot open the datafile "Y:\FILE5945031821.txt". End Error Error: 2021-03-18 21:28:44.93 Code: 0xC004701A Source: Data Flow Task 1 SSIS.Pipeline Description: Flat File Destination failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:28:43 PM Finished: 9:28:44 PM Elapsed: 1.063 seconds. The package execution failed. The step failed.
When I run it successfully I am logged on as DOMAIN\DomainAdmin. That account is a domain admin. This appears to be a permission issue however the package is being ran under the same credentials both ways. Any help would be appreciated.