hello everyone,

i am attempting to design a dts package. i created a connection and a text
file destination.
i now want to perform a transform data task. i click the connection as the
source and the text file as the destination.
i set a sql statement as the data source, the next step is to click the
destination tab, where i can define the columns,
populate from the source and execute. in the help file it says i can change
the column size:


Size
Type the column size for a selected destination column.


however, i cannot change the column size. how do i change the column size so
my data isn't truncated?
it is truncating data on a complex column.

thank you for your help.