title: SQL SERVER 2008 - SSIS Excel Destination
body: <p>I am currently trying to use SSIS to export a large dataset into an Excel destination, however the issue that i have for one of my columns is that records within it exceeds that maximum amount of characters allowed to export. Currently it is set to 255 using Data type  <code>DT_WSTR</code>.</p>
  
  <p>To give you a bit of background I had to use the data conversion tool for a few of my source columns to convert from <code>String [DT_STR]</code> to <code>[DT_WSTR]</code> which partially solved my problem by allowing me to export into excel, except for those records which exceeded the character limit. For now I have just setup a multicast and redirected those records.</p>
  
  <p>Is there any way to get around this?</p>