NTEXT data is getting truncated in text file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

NTEXT data is getting truncated in text file

Hi We have a DTS Package which dumps the data to a text file
The Query has NTEXT column When we execute the DTS Package, The Ntext data is truncated to 255 characters in the destination text file. But we are able to see the complete data which is more than 255 characters for NTEXT column. when we execute the same query in Query Analyzer, How can i get the complete data for NTEXT column in the destination text file Please Help me out this. Thanks in advance
Have you tired with BCP in this case? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
No..i have tried differently by having only NTEXT column in the SELECT query and omitted remaining columns and executed the package. This time NTEXT is not getting truncated. The NTEXT data is only being truncated if specified along with remaining columns.