title: Excel destination character size in SSIS
body: <p>I am trying to export data from SQL server 2008 to Excel file using BIDS.
  One of the fields 'DESCRIPTION' coming from SQL database is VARCHAR(4000).
  I can export everything to excel but the 'DESCRIPTION' field size in excel is  restricted to unicode 255 and no mater what I try it does not allow me to export the data over 255 characters (exports it as blank). I tried to change SQL field as varchar(max) or ntext but none of attempts worked. I used advanced editor in BIDS on excel destination to change 'DESCRIPTION' character length manually but as soon as I hit 'OK', it resets to unicode 255.
  Could anybody please help me to resolve this issue?</p>
  
  <p>Thanks,
  Vishal</p>