When using SSMA 2008 for Sybase for Data migration “text” columns may get truncated to a maximum of 32K
Text columns can get truncated because of default value of textsize property.
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:
(Note: Change Provider according to your version)
Article Id: KBS2SS1008
• SSMA 2005 for Sybase
• SSMA 2008 for Sybase