sql server dts: I am importing a file into a database with a field that is ntext. (I can not
change the type of field in the destination.)The field I am having problems
with contains a lot of text. It keeps getting either truncated or is
completely missing, with no errors. I've tried using both Excel and Access as
the source files and get the same results. I tried an Access file where the
field was a memo, with as many as 5000 characters. How can I force the DTS to
copy the text (or as much of it as possible) into this ntext field?

I figured it out, in case anyone else comes across this. First, I was
importing an Access text field (only 255 characters) into a SQL ntext field,
so it was of course losing everything that was over 255 characters. After I
changed the Access field to a memo field, I thought I still had a problem
because I couldn't see the data in SQL Enterprise Manager, but it turned out
that with ntext fields in SQL Enterprise Manager, you can't see data that's
longer than the column's physical length because it uses a pointer to the
actual location of large values.
--
Matt Wittemann, CRM MVP
http://icu-mscrm.blogspot.com


[quoted text, click to view]