Data for source column 14 ('TRN_NOTE') is too large for the specified buffer size.

#1

When I am doing dts from SQL Server to Oracle, on one of the tables I am
getting this error

Data for source column 14 ('TRN_NOTE') is too large for the specified buffer
size.

Where is this buffer and why am I getting this. How to avoid this problem.

TRN_NOTE is and NTEXT column.

-Nags

#2

ntext can take 1,073,741,823 characters.
The oracle table column into which you are putting this
value may not be able to accept this large value.

Quote:

-----Original Message-----
When I am doing dts from SQL Server to Oracle, on one of
the tables I am
getting this error

Data for source column 14 ('TRN_NOTE') is too large for
the specified buffer
size.

Where is this buffer and why am I getting this. How to
avoid this problem.

TRN_NOTE is and NTEXT column.

-Nags

.

#3

Yup. Found the issue. We assumed that the column in Oracle would be CLOB,
but I think there was a problem in the table creation script.

-Nags
"partha" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

ntext can take 1,073,741,823 characters.
The oracle table column into which you are putting this
value may not be able to accept this large value.
-----Original Message-----
When I am doing dts from SQL Server to Oracle, on one of
the tables I am
getting this error

Data for source column 14 ('TRN_NOTE') is too large for
the specified buffer
size.

Where is this buffer and why am I getting this. How to
avoid this problem.

TRN_NOTE is and NTEXT column.

-Nags

.

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

Data for source column 14 ('TRN_NOTE') is too large for the specified buffer size.

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

Data for source column 14 ('TRN_NOTE') is too large for the specified buffer size. - 05-07-2004 , 12:50 PM

Data for source column 14 ('TRN_NOTE') is too large for the specified buffer size. - 05-07-2004 , 01:57 PM

Re: Data for source column 14 ('TRN_NOTE') is too large for the specified buffer size. - 05-07-2004 , 02:51 PM