September 22, 2003 at 10:50 am
I am getting the following error when importing from Access Memo field 'Remarks' to SQL Field varchar(7000) 'Remarks'
"Microsoft Data Transformation Services (DTS) Data Pump , Data for source column 8 ('remarks') is too large for the specified buffer size'
I thought the problem might be similar to the FAQ "Why do I receive buffer size errors when trying to import an Excel spreadsheet?"
http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=63
But I can not find a Registry entry for Access.
September 23, 2003 at 3:04 am
Access Memo field equates to SQL text field and allows for text greater than 255 for Access and 8000 for SQL. If you try to DTS a memo column that has text longer than the destination (7000 in your case) then you get this error.
Far away is close at hand in the images of elsewhere.
Anon.
September 23, 2003 at 4:38 am
I thought a solution might be to use left(remarks,7000) on the source field but this made no difference. I thought I might then try to trim trailing white space in the transformation. This actually worked without the left function removing the traling 1500 characters over 7000! Not sure why this worked?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply