hi,

we are trying to build SSIS package that transfers records from SQL 2005
table to excel sheet. the table contains nvarchar fields with long values (up
to 1000 chars)

we always get the warning below and any string value longer than 255 chars
is truncated. we changed the length properety of the destination excel column
but it didn't help and it always get back to default value (under input and
output properties tab).

please advice.

the warning message:
Validation warning. Data Flow Task: Excel Destination [2526]: Truncation may
occur due to inserting data from data flow column "English" with a length of
1000 to database column "English" with a length of 255

thanks

rafi