Adam Bell
asked on
SQL Server 7 Text Truncation on Export
Hi,
I'm migrating a legacy sql 7/VB app... Several Text fields defined length 16, hold plain and rtf tagged text variously.
It appears that the rich text field in the VB app successfully display the text, plain or rtf, at its full length (>1000 chars) as entered, and can be copied manually via the Windows clipboard.
However when I export using Dts, or access the SQL db using Access 2003 the stored text is consistently truncated to <255 characters - I've seen articles referring to a 255 character limit requiring specific VBA syntax to workaround when storing text in SQL server older versions, and if as it appears the same issue applies to DTS export, wonder if anyone knows of a workaround on the backend ? or conversion tool compatible with SQL Server 7 ? (plenty for newer versions but cant find one that connects to SS7).
I've seen another article which refers to special characters causing text processing issues which could be relevant with the rtf tags being present. But seems less likely.
Any guidance or suggestions gratefully received...
I'm migrating a legacy sql 7/VB app... Several Text fields defined length 16, hold plain and rtf tagged text variously.
It appears that the rich text field in the VB app successfully display the text, plain or rtf, at its full length (>1000 chars) as entered, and can be copied manually via the Windows clipboard.
However when I export using Dts, or access the SQL db using Access 2003 the stored text is consistently truncated to <255 characters - I've seen articles referring to a 255 character limit requiring specific VBA syntax to workaround when storing text in SQL server older versions, and if as it appears the same issue applies to DTS export, wonder if anyone knows of a workaround on the backend ? or conversion tool compatible with SQL Server 7 ? (plenty for newer versions but cant find one that connects to SS7).
I've seen another article which refers to special characters causing text processing issues which could be relevant with the rtf tags being present. But seems less likely.
Any guidance or suggestions gratefully received...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
After some testing was able to Dts transform in the data export wizard to CSV... The Dts package was defaulting to 255...thanks for pointing this out...
ASKER