sql server data warehouse: DTS Error - Data too large for specified buffer size -- sql server data warehouse

DTS Error - Data too large for specified buffer size

Scott Natwick
11/23/2004 9:58:24 AM

sql server data warehouse:

I'm trying to import data into my table and I'm received an error message
that I've been able 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

Re: DTS Error - Data too large for specified buffer size

Scott Natwick
11/23/2004 2:00:43 PM

It's working now.

This link was helpful as well I switched from ODBC to OLE connection.

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

Thanks,
Scott

[quoted text, click to view]