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

partha
5/7/2004 11:57:38 AM

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.
[quoted text, click to view]

Nags
5/7/2004 1:50:37 PM

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

Nags
5/7/2004 3:51:21 PM

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
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

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