Ask Paula!

...bringing you notes from the field...

  Home  |   Contact  |   Syndication    |   Login
  147 Posts | 5 Stories | 133 Comments | 0 Trackbacks

News

Copyright © 2008-2018 Paula DiTallo

Tag Cloud


Archives

Post Categories

.NET Development

Enterprise Integration

Entertainment - Games

Java Development

Mobile/PDA Development

Professional Affiliations

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.
posted on 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 8/13/2013 8:30 AM Menahem Shcolnick
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".


# re: SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer 6/14/2014 10:18 AM viki
Me also facing the same problem .. in my case unicode property also set to false

# re: SSIS: I get the error The column data for column "Column x" overflowed the disk I/O buffer 1/11/2016 11:54 AM Roman K
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.

Post A Comment
Title:
Name:
Email:
Comment:
Verification: