Unicode and SQL Server

• Question

• 

  

  0

  Sign in to vote

  I am trying to import an Excel file into a database using a SSIS package in SQL 2005 I get the error message of "cannot convert between unicode and non-unicode string data types "
  This same file can be imported into the old SQL databases using a dts package.
  I do not want the SQL server to use the Unicode.
  Any ideas?
  thanks
  

  • Moved by Tony Petrossian Tuesday, June 24, 2008 8:32 PM off topic

  Tuesday, June 10, 2008 4:16 PM