Unicode and SQL Server RRS feed

  • Question

  • 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?
    Tuesday, June 10, 2008 4:16 PM