The column data for column "TranDate3" overflowed the disk I/O buffer.

thomaszhwang used Ask the Experts™
When I use SSIS to load a CSV file into a staging database, I encountered the following error.

Error: 0xC020209C at Load Data from the CSV file to the Staging Table, Encumbrance Flat File Source [1]: The column data for column "TranDate3" overflowed the disk I/O buffer.

Does anyone know how should I fix this?  Thanks.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
AdamSenior Developer

What's the actual data in the CSV file that's causing the overflow?
Also, what's the column type of the column the data is being inserted into?

If you could provide the SQL to create your table, and attach a few lines from your CSV file, including one that causes the problem, that would be really useful.


The actual data in the CSV file are Dates.

The column type of the column the data is being inserted into is also Date.

Please refer to the attachments for the files you are looking for.

Since the data source contains sensitive information, I only uploaded the primary key column and the column caused the error.

I also attached the detailed error message.

Please help.  Thanks.
Senior Developer
Sorry for the delay.

I created the table, using the SQL, and imported the data, using the SQL Server Import Wizard.
I imported the TDPrimaryKey column into the TransactionID column, and the TranDate3 column into the Transaction_Date_3 column.

All the data imported without error - I couldn't reproduce the error.

I am a little confused by the table design though.
All fields were varchar(255), despite the type of data the column name (e.g. Transaction_Date_3, presumably a date) would suggest. Is the live table really designed like this?


Thanks Cyber-spy.

I finally found out the reason.  When this file is exported, it was using a different line feed.  That's why the other files were working file.  After I re-export the file with the same type of line feed, the problem was fixed.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial