DTS Testing Transform Task failure... -
01-12-2004
, 08:15 AM
I am using DTS in SQL Server 2000 to transfer data between Paradox 5
tables to a Oracle 8.1.7 database (using Oracle OLEDB Provider
8.1.7.3)
Everything works fine except for one table which contains 2 memo
fields in paradox. I used two varchar2 4000 on the destination table.
When running a test transfer, I get "Data for source column
("CFIParameters") is too large for the specified buffer size".
CFIParameters is one of the two memo fields. Where can I enlarge this
"Specified Buffer Size"? I am certain I have much bigger fields being
transferred elsewhere.
Thanks in advance,
Jeff Lambert
Hypershell, Inc.
jeffl (AT) hypershell (DOT) com |