Home Forums SQL Server 2008 Working with Oracle Cannot convert between unicode and non-unicode string data types RE: Cannot convert between unicode and non-unicode string data types

  • I doubt it has anything to do with the 64-bit or running it in a SQL Agent job. There are definitely plenty of Unicode characters that won't convert to a non-unicode string. Try changing the error output for the conversion step to redirect the row out to a flat file rather than fail the component and have a look if there are any weird characters in it.