DTS Data Pump Buffer size error

#1

Using DTS and SQL 7 the DTS data pump generates the
following error: Data for source column is too large for
the specified buffersize. We can get it to work by
chopping off the data in the offending field (to about 512
characters of text) but it would be much better if we
could just change the buffer size. Anyone know where we
can change the buffer size for the dts data pump? We've
looked for months and still no luck.

#2

Transforming text from Excel to SQL database.

Quote:

-----Original Message-----
What is the destination? Is it a Jet database ?

http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:
80/support/kb/articles/Q281/5/17.ASP&NoWebContent=1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"jim" <james (AT) adworkshop (DOT) com> wrote in message
news:04a401c33f49$a5f78350$a101280a (AT) phx (DOT) gbl...
Using DTS and SQL 7 the DTS data pump generates the
following error: Data for source column is too large for
the specified buffersize. We can get it to work by
chopping off the data in the offending field (to about
512
characters of text) but it would be much better if we
could just change the buffer size. Anyone know where we
can change the buffer size for the dts data pump? We've
looked for months and still no luck.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Data Pump Buffer size error

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Data Pump Buffer size error - 06-30-2003 , 03:53 PM

Re: DTS Data Pump Buffer size error - 07-01-2003 , 08:38 AM