buffer too small for DTS 1

[sharonc]

I'm trying to run a dts package and I'm getting the error that the buffer is too small for a field.

This loads SQL Server from an MS Access database. The field that I'm having trouble loading is a memo field.

How do I increase the buffer size?

 

[tlbroadbent]

Check this MS Article.

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 Broadbent


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

 

[sharonc]

thank you so much. That was the perfect answer.