Text exported from Sql server 7 truncated

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 as entered.

However when I export using Dts to Csv,  or access the SQL db using Access 2003 the text,  plain or in rtf tagged form,  truncated.

I've seen articles referring to a 255 character limit without specific syntax when storing text in SQL server older versions,  and wonder if same could apply to  export?

I've seen another article that refers to 1024 setting in odbc bindings,  but this seems inconsistent with Dts.

I've seen another article which refers to special characters causing text processing issues which would seem  relevant with the rtf tags being present.

It is possible to copy and paste the text using Windows clipboard..  But there are too many records to be practical.

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.

Norm DickinsonGuruCommented:
Perhaps you could export those fields to the new database using a different field type, such as a memo type of field?
0
RingahAuthor Commented:
Thanks for the feedback Norm... The server doesn't seem to support memo,  too old,  char only seems to be 8000 bytes,  but user defined might run...
0
Norm DickinsonGuruCommented:
Or maybe export to a regular text file or RTF file and then import to the new database from the file?
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

RingahAuthor Commented:
Thanks Norm,  will try both..
0
RingahAuthor Commented:
Turns out to be related to Dts.... Thanks for the pointer Norm,  if I hadn't have been using such an old version of SQL server you'd be spot on.
0
Norm DickinsonGuruCommented:
Thanks, Ringah. I hope it helped a little anyway. Feel free to accept the answer and award pointsif you don't mind and re-post the question with reference to what you tried in this question, if you need further information, as these questions do not get as much attention once we have interacted on them. You have an unlimited number of points and questions available as this is a time-based subscription. As experts, our only reward for helping - other than the satisfaction - is the point award for each question answered. See "The Experts" below - and then click on how to become an expert to see. You may have something to contribute and in doing so you may earn your membership here for free. It's worth looking into. Thanks and good luck!
0
RingahAuthor Commented:
To expand,  and widen the horizons for anyone else who comes across similar problems,  for more recent versions of SQL migrating to a different file type,  whether larger or offering rtf support is probably the first course of action for anyone facing similar issues...

For older versions or where specific manipulation is required,  Dts packages offer a lot of options in both respects...
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 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.