December 3, 2008 at 12:33 pm
I am trying to import a text file into SQL Server DB I am getting the following error:
[Flat File Source [267]] Error: The column data for column "Column 0" overflowed the disk I/O buffer.
I have tried adding a OLE DB Destination object and redirect the rows but the package fails before it can insert any records into the destination object.
Any suggestions -- I was also trying to do this manually via MSS Management Studio but was getting a conversion error which seem to be related to unicode and non-unicode data. I corrected this when attempting to do the process via a package by changing the data types of the destination table to accept the incoming data type (varchar).
Thanks in advance for any help.
December 3, 2008 at 1:38 pm
Without knowing more about your data flow, I don't know exactly what advice to offer. Have you verified that in each case the db columns are wide enough to receive the inbound data? Also, have you verified that your row delimiter is correct?
December 3, 2008 at 1:41 pm
Try setting the the flat file source object to unicode. Found this here, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1200198&SiteID=1
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 4, 2008 at 9:12 am
It looks as if there is a shift in some of the end columns -- I have decided to ask the client to re-export and send to me.
Appreciate the suggestions.
December 4, 2008 at 9:16 am
It could potentially be the incorrect column delimiter in the file?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply