SSIS is copying files from/to network path (share) while running from business studio (BI) but failing when executed from SQL Server as job (Error Code : 0xC020200E)
Most likely you have a SSIS package to copy file (data) to or from a network location (which is a mapped drive at your server) and the package works perfectly when you run it from business development studio. But problem starts when you run it as a SQL Server job and it fails throwing errors like below: Executed as user: [ ]. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: [ ] Error: [ ] Code: 0xC020200E Source: Data Flow Component Flat File Source [33] Description: Cannot open the datafile "[ ]". End Error Error: [ ] Code: 0xC004701A Source: Data Flow Component SSIS.Pipeline Description: component "Flat File Source" (33) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: [ ] Finished: [ ] Elapsed: [ ]. The package execution fail