Tuesday, August 4, 2009

Text columns get truncated to a size of 32K

Symptom
When using SSMA 2008 for Sybase for Data migration “text” columns may get truncated to a maximum of 32K

Cause
Text columns can get truncated because of default value of textsize property.

Resolution
Text columns can get truncated because of default value of textsize property. The default size of TextSize attribute of Oledb provider is 32K so if the data is more than 32K , its getting truncated in your case.
As a workaround, you can set the connection string in advanced mode to connect to Sybase.

In the connection string include a parameter ‘textsize’ as shown and assign it the maximum number of characters you have in all your text columns ,so that it won’t truncate data.
Sample connection string:
User ID=myID;PWD=abc;Provider=ASEOLEDB.1;Server=myserver;Port=5000;Database=master;
textsize=;
(Note: Change Provider according to your version)

More Information
Article Id: KBS2SS1008

Applies to
• SSMA 2005 for Sybase
• SSMA 2008 for Sybase

No comments:

Post a Comment