title: SSIS Convert Between Unicode and Non-Unicode Error
body: <p>I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL statement to create the sheet in the Excel workbook, the SQL is in the excel connection manager (effectively a create table statement that creates a sheet) and is derived from the mapping of the columns from the DB.</p>
  
  <p>No matter what I have done I keep getting this unicode --> non-unicode conversion error between my source and destination. Tried conversion to string[DT_STR] between S > D, removed it, changed SQL Table VARCHAR to NVARCHAR and still get this flippin error. </p>
  
  <p>Because I am creating the sheet in Excel with a SQL statement I do not see any way to actually pre-define what the data types of the columns will be in the Excel sheet. I imagine it would be a default meta data but I do not know.</p>
  
  <p>So between my SQL table destination and the creation of my Excel sheet with this SSIS sql statement how can I stop this error coming up?</p>
  
  <p>My error is:</p>
  
  <blockquote>
    <p>Error at Data Flow Task [OLE DB Source [1]]: Column "MyColumn" cannot convert between unicode and non-unicode string data types.</p>
  </blockquote>
  
  <p>And for all nvarchar columns.</p>
  
  <p>Appreciate any help</p>
  
  <p>Thanks</p>
  
  <p>Andrew</p>