August 2, 2007 at 8:08 am
I'm importing an Excel document into a table
I receive the following error:
"Data for source column (description) is too large for the specified buffer size"
Format description in table is ntext.
Please advise what to do?
August 2, 2007 at 9:28 am
I've heard of this problem before. It has to do with variable data lengths in the source. The usual advice is to try the workaround in this KB article: http://support.microsoft.com/kb/281517/en-us
Greg
Greg
August 3, 2007 at 12:59 am
The solution of my problem could be sorting the LEN(description) desc so SQL will recognize this, but how can I sort an excel sheet in the my tranform data task?
Do I need an VB Transformation script between my source and destination?
How can I do this or am I wrong?
August 29, 2007 at 7:30 am
I too faced a similar problem. The link provided by Charles had the fix. I did not tweak the Registry but just edited my XL file so that the row with the huge colm width was in the first 8 rows of my XL sheet and that did the trick
Thanks guys.
Sanjay
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply