SQL Server Performance

NTEXT data is getting truncated in text file

Discussion in 'SQL Server DTS-Related Questions' started by haridba, Jun 28, 2007.

  1. haridba New Member


    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
  2. satya Moderator

    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.
  3. haridba New Member

    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.

Share This Page