The column data for column "TranDate3" overflowed the disk I/O buffer.
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.
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.
Last Comment
ASKER
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
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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.
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.