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

thomaszhwang
thomaszhwang used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

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

Commented:
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.

Author

Commented:
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.
Create-Table.sql
Data-Source.csv
Error-Message.txt
Senior Developer
Commented:
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?

Author

Commented:
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