News

Copyright © 2008-2019 Paula DiTallo

Tag Cloud


<< Eclipse Project:: How do I add an external *.jar file to my project? | Home | SQL Server Agent:: I Can't Edit a Job Step because of the error "Creating an instance of the COM component with CLSID from the IClassFactory failed" >>

SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer

If you are reading a flat file, you are missing a delimiter somewhere and SSIS is trying to parse for the next value--so it thows an i/o buffer error. Look in the file for the missing delimiter. If the file is too big for that, try chopping up the file up into smaller versions until you find the line with the missing delimiter.
Friday, March 15, 2013 5:34 PM

Feedback

# re: SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer

It can happen when you:
Create a file with a "File Connection Manager" property "Unicode" Set to "True".
Trying to import it via SSIS with a "File Connection Manager" property "Unicode" Set to "False".
8/13/2013 8:30 AM | Menahem Shcolnick

# re: SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer

Me also facing the same problem .. in my case unicode property also set to false 6/14/2014 10:18 AM | viki

# re: SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer

Also it happens when your file has Unicode encoding but file connection manager does not have a checkmark set near Unicode property. Or vise verso, file is not Unicode when connection manager is Unicode. 1/11/2016 11:54 AM | Roman K
Post A Comment
Title:
Name:
Email:
Comment:
Verification: