Home > Archive > MS SQL Server > June 2005 > data truncated when exported via DTS transform task









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author data truncated when exported via DTS transform task
Sanjay

2005-06-20, 11:23 am

I have a DTS transform task where i am exporting data into a tab delimeted
flat file from a table where column is defined as varchar(500)
What i noticed is that data is truncated after 255 characters for this
column when i export this into a tab delimeted file.

Te length of column shows as 500 chars even in Destination tab of DTS
transform task

Pls help

Thanks



John Bell

2005-06-20, 11:23 am

Hi

Have you seen http://www.sqldts.com/default.aspx?297

John


"Sanjay" wrote:

> I have a DTS transform task where i am exporting data into a tab delimeted
> flat file from a table where column is defined as varchar(500)
> What i noticed is that data is truncated after 255 characters for this
> column when i export this into a tab delimeted file.
>
> Te length of column shows as 500 chars even in Destination tab of DTS
> transform task
>
> Pls help
>
> Thanks
>
>
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com