DTS error

Question

DTS error

Swimmer

SSC Enthusiast

Points: 100
More actions
August 2, 2007 at 8:08 am

#177762

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?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

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

Swimmer SSC Enthusiast Points: 100 More actions · Answer 2

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?

Sanjay Paul Newbie Points: 1 More actions · Answer 3

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