An disk I/O time out occurred while reading the file in SSIS. Error 0xC020209E
I have a schedule SSIS job under SQL Server Agent (SQL Server 2008 64Bits) to run daily. It failed two or three times in a week, but it never failed if I start the job manually. The job uses my Window Credentials to excute the job. Any advaices are very appreciated. HELP. Here is the message: Executed as user: domain\user. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 6:37:13 AM DTExec: The package execution returned DTSER_SUCCESS (0). Started: 6:37:13 AM Finished: 6:38:30 AM Elapsed: 76.768 seconds. The package executed successfully. The step succeeded.,00:01:17,0,0,,,,0 07/08/2010 06:30:00,Daily FTP Job,Success,1,ServerName,Daily FTP Job,FTP Step 1,,Executed as user: domain\user. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 6:30:00 AM DTExec: The package execution returned DTSER_SUCCESS (0). Started: 6:30:00 AM Finished: 6:37:11 AM Elapsed: 431.03 seconds. The package executed successfully. The step succeeded.,00:07:12,0,0,,,,0 07/08/2010 06:15:00,Daily FTP Job,Error,0,ServerName,Daily FTP Job,(Job outcome),,The job failed. The Job was invoked by Schedule 9 (Daily FTP Schedule). The last step to run was step 1 (FTP Step 1).,00:01:14,0,0,FTP,,,0 07/08/2010 06:15:00,Daily FTP Job,Error,1,ServerName,Daily FTP Job,FTP Step 1,,Executed as user: domain\user. ...sion 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 6:15:00 AM Error: 2010-07-08 06:16:14.23 Code: 0xC020209D Source: Data Flow Task Name [13238] Description: An unexpected disk I/O error occurred while reading the file.
July 8th, 2010 5:29pm

Hi JustCoder, The following error generally happen if there is a disk I/O error or the traget file is corrupt. Code: 0xC020209D Source: Data Flow Task Name [13238] Description: An unexpected disk I/O error occurred while reading the file. I would suggest to try there steps to check if the issue is solved: 1. Make sure the file is fine. 2. Move the file to another partition. 3. Move the file to another disk. May be you are using a static file for every job, that may cause the file to be locked by uncompleted job. So, could you please set one file for each job, and then check if this works? Additionally, there may have System log which describe the detailed error message about I/O error, could you please help to collect and post it? If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2010 1:31pm

Hi Jin Chen, I have the same error here. 1. Below is my test scenario: a. The package has only 1 DFT to load multiple csv file (10MB each) to OLE DB destination b. This package is schedule using SQL Server Agent. 2 jobs are scheduled using the same package and running in parallel. 2. Sometimes, both jobs are successful but most of the time, both jobs are failed. Below is the error message: Executed as user: EUROPE\IS-EAI-SQLAGENT-P-S. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:18:07 AM Error: 2011-03-28 04:18:09.26 Code: 0xC020209D Source: Data Flow Task Flat File Source [145] Description: An unexpected disk I/O error occurred while reading the file. End Error Error: 2011-03-28 04:18:09.26 Code: 0xC0047038 Source: Data Flow Task SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (145) returned error code 0xC020209D. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:18:07 AM Finished: 4:18:09 AM Elapsed: 7200.89 seconds. The package execution failed. The step failed 3. From your previous post, the error could due to disk IO error or target file is corrupted. I've tried below but no luck. There is no error or warning at eventvwr when this job failed. From perfmon, the logical and physical counter shown the data is not fully loaded, the job failed when 27/400 files are inserted, and perfmon also shown server are not loaded during the failure a. Make sure the file is fine. b. Move the file to another partition. c. Move the file to another disk. 4. Do you think my scenario is consider as disk I/O error or target file locked by running job? Please guide me the next step if it is disk I/O error. Thanks.
March 29th, 2011 11:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics