Buffer Size

[fiber0pti]

When trying to import an xls file I get an error that one of my columns is to large for the current buffer size, how do I raise the buffer size?

 

[tlbroadbent]

A column is being truncated. Check this article for a fix.

PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error

http://support.microsoft.com/support/kb/articles/Q281/5/17.asp

Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[fiber0pti]

That didn't work, does anyone else have any suggestions?

 

[AshleyRickards]

Try converting the Excel sheet to CSV. On import check the field size and type. Modify if needed.

HTH
ASH Ashley L RIckards
SQL DBA

 

[fiber0pti]

How do I import it if it's a csv file? I don't see that it's supported.

 

[AshleyRickards]

Import as text file for the source. DTS should detect the comma delimter. Ashley L Rickards
SQL DBA