I'm trying to import data into my table and I'm received an error message
that I've been unable to resolve.

The message is:
Error Source: Microsoft Transformation Services (DTS) Data Pump
Error Description: Data for source column 3 ("column_name") is too large for
the specified buffer size.

The destination column size is 500 in the table and the data in the import
file for that row and column is 280 characters.

Any ideas?

Thanks in advance,
Scott

Did you look at Google?

Have a look at this

http://support.microsoft.com/kb/281517/EN-US/

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Scott Natwick" <nospamplease (AT) yahoo (DOT) com> wrote

Thanks Allan,

Yes, I did see that link in an earlier post. I changed the registry setting
to 0 and moved my row with the long string to the top of the file.

However, I still get the error. I've searched and searched on google, but
haven't a workaround for this problem. As indicated in the link you
provided, it does seem to be caused by a field string greater than 255
characters. When I cut the string down to less than this value, it loads
OK.

I'm stuck. Thanks for any thoughts.
Scott

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Ok, whew, it's working now.

I also switched from ODBC to OLE connection and it goes through.

Thanks,
Scott

"Scott Natwick" <nospamplease (AT) yahoo (DOT) com> wrote

Great to her it's working for you now

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Scott Natwick" <nospamplease (AT) yahoo (DOT) com> wrote