June 21, 2002 at 6:13 am
I have been running the same package for months now and suddenly I am getting an error "Datasource for Column 17 (column name) is to large for the specified buffer size." What do I do about this to fix it? Why is this all of a sudden happening?
Any help that I can get a.s.a.p. would be appreciated as this is a production database and we NEED this data badly.
Thanks
June 21, 2002 at 6:21 am
Sounds like the lenght of the field you are inserting into is smaller than the data coming in. Check your table where column 17 is being inserted and check the max length of column 17 and make sure match.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 21, 2002 at 6:31 am
The datatype coming from Access is memo and the field in my SQL2k table is ntext. I have played around testing it with text and varchar(4000), but it still doesn't work. This has been running for months. I have no idea why this is happening now. Any other work arounds?
quote:
Sounds like the lenght of the field you are inserting into is smaller than the data coming in. Check your table where column 17 is being inserted and check the max length of column 17 and make sure match."Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 21, 2002 at 9:24 am
I believe your problem is related to this article http://webferret.search.com/click?wf,+%2Bdts+%2Bis+to+large+for+the+specified+buffer+size,,support.microsoft.com%2Fsupport%2Fkb%2Farticles%2FQ281%2F5%2F17.asp,,aol in regards to typerguess from Jet4.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply