Post reply

DTS and Length of NVARCHAR fields

  • May 4, 2006 at 12:15 am

    #67366

    Dear all,

    I have a DTS that extracts the data of a table into a TXT file.  One of the fields is NVARCHAR(4000).  When the file is extracted this field gets truncated to 255 Characters.  Does anyone know whether there is a restriction in DTSs as far as the length of NVARCHAR fields is concerned?

    If yes, is there a workaround for this?

    Thanks & Regards,

    Andreas Kantounas

  • May 4, 2006 at 1:28 am

    #635850

    This will do the trick for you.
     

    In SQL Server 2000, an additional workaround exists if the delimited text files must be used. When you use the DTS Import/Export Wizard to export data to a delimited text file, first save the package, and then open the package in the DTS Designer. In the DTS Designer, click Package, and then click Disconnected Edit to open the package in Disconnected Edit mode. Expand Connections, expand the text file connection object, and then expand OLEDB Properties. Finally, change the value of "Max characters per delimited column" to 8,000.
     
     

  • May 4, 2006 at 1:54 am

    #635854

    Job well done!!!

    Thanks a lot.

    Andreas

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply