Post reply

DTS truncating field in export to text file

  • September 1, 2004 at 7:09 pm

    #60206

    HI

    I have made a package that imports a table from a FoxPro DB into a SQL Server table and then exports the table from SQL Server to a comma delimited file. This works ok except that when I export the table from the SQL Server to the text file one field is truncated.

    The offending field is a 'notes/memo' type field that has carriage returns in it. The maximum field data length is 3896 characters so I have made the field varchar(4000).

    Curiosuly when I export directly from FoxPro to a text file via DTS this field is not truncated

    but I really need to import it into a SQL Server table first so I can perform some data scrubbing e.g removing trailing spaces etc.

    Does anyone know why SQL Server is truncating this field on export?

    Thanks

    Simon

     

      

     

     

  • September 2, 2004 at 7:20 am

    #521501

    Simon,

    If you are running on XP take a look at the thread on this site entitled "XP SP2 screwing up DTS transform on Text field" If that doesn't help try http://www.sqldts.com there are some articles there discussing text fields and size issues.

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

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