Error 0xC020200E - cannot open datafile
I am new to SQL Server 2008 R2 and would appreciate some assistance please.
I have a package which imports a flat file named CAST into a SQL Server table. When the package is executed from MSDB it runs successfully.
However, when the same package is run from a job from SQL Server Agent, the job fails. Here is the error message:
Step ID 1
Job Name ImportCAST
Step Name ImportCAST
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
Executed as user: CNSWFL\cnswflsql. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:25:19 AM Error: 2012-09-19 08:25:23.83 Code: 0xC020200E Source: Data Flow Task 1 Source - CAST  Description: Cannot open the datafile "T:\FSFN_Data\FSFN_Extract_Files\CAST". End Error Error: 2012-09-19 08:25:23.84 Code: 0xC004701A Source: Data Flow Task 1 SSIS.Pipeline Description: component "Source - CAST" (1) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:25:19 AM Finished: 8:25:23 AM Elapsed: 3.869 seconds. The package execution failed. The step failed.
I have researched this error code on the internet, have tried several solutions and am still stumped. Any advice would be greatly appreciated.