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...
RingahAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott PletcherSenior DBACommented:
DTS creates a package.  I think by default the length was set to 255, but you can override that.  Sorry, I don't remember the details of anything in SQL 7.0 and I don't have any instance to try it on.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RingahAuthor Commented:
Thanks Scott,  will dig out info on that from technet,  makes sense that there's a way around as this ver of SQL was heavily text based...
0
RingahAuthor Commented:
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...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.