Increasing the Text Size for the Adaptive Server ODBC Driver

The Adaptive Server ODBC driver truncates text or image data values that are larger than the value set in the ODBC configuration in Microsoft Windows for the driver. You must increase the text size value in the ODBC Control Panel, or set the value in the database options parameter for your database connection to avoid this issue.

Increasing the Text Size Value Using the Control Panel
Use the Control Panel to update the text size value.
Increasing the Text Size Value Using Database Options
Use the Properties window for the database connection to set the text size value.

Parent topic: Best Practices for Working with ETL Project Components

Created May 24, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com