p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning Microsoft SQL Server 2008 Programming ISBN: 978-0-470-25701-2 (http://p2p.wrox.com/forumdisplay.php?f=425)
-   -   Error 0xC020200E - cannot open datafile (http://p2p.wrox.com/showthread.php?t=88478)

kalltc September 19th, 2012 08:50 AM

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.

All times are GMT -4. The time now is 05:40 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.