View Single Post
  #1 (permalink)  
Old September 19th, 2012, 08:50 AM
kalltc kalltc is offline
Registered User
Points: 5, Level: 1
Points: 5, Level: 1 Points: 5, Level: 1 Points: 5, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Sep 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Duration 00:00:04
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
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 [1] 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.
Reply With Quote