SSIS Convert Between Unicode and Non-Unicode Error

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.

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.

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.

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?

My error is:

Error at Data Flow Task [OLE DB Source [1]]: Column “MyColumn” cannot convert between unicode and non-unicode string data types.

And for all nvarchar columns.

Appreciate any help

Thanks

Andrew

Related Posts:

  1. What is the SSIS package and what does it do?
  2. SSIS Control Flow vs Data Flow
  3. How to resolve TypeError: can only concatenate str (not “int”) to str [duplicate]
  4. How to correct TypeError: Unicode-objects must be encoded before hashing?
  5. How to replace � in a string
  6. Invisible characters – ASCII
  7. What’s the difference between ASCII and Unicode?
  8. Tallest Unicode character?
  9. What’s the difference between ASCII and Unicode?
  10. u’\ufeff’ in Python string
  11. How to remove \xa0 from string in Python?
  12. How to remove this \xa0 from a string in python?
  13. What’s the difference between ASCII and Unicode?
  14. What does the ‘b’ character do in front of a string literal?
  15. What does the ‘b’ character do in front of a string literal?
  16. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  17. Using awk to remove the Byte-order mark
  18. python encoding utf-8
  19. What is the difference between UTF-8 and Unicode?
  20. UnicodeDecodeError: ‘charmap’ codec can’t decode byte X in position Y: character maps to
  21. (unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape
  22. What’s the complete range for Chinese characters in Unicode?
  23. What’s up with these Unicode combining characters and how can we filter them?
  24. Unicode range for Japanese
  25. “Unicode Error “unicodeescape” codec can’t decode bytes… Cannot open text files in Python 3
  26. Python – ‘ascii’ codec can’t decode byte
  27. UnicodeEncodeError: ‘ascii’ codec can’t encode character u’\xa0′ in position 20: ordinal not in range(128)
  28. std::wstring VS std::string
  29. How do I fix ‘Invalid character value for cast specification’ on a date column in flat file?
  30. Python string prints as [u’String’]
  31. NameError: global name ‘unicode’ is not defined – in Python 3
  32. Convert a Unicode string to a string in Python (containing extra symbols)python string unicode type-conversion
  33. Best way to reverse a string
  34. Using unicode character u201c
  35. ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
  36. How do I fix the multiple-step OLE DB operation errors in SSIS?
  37. What is a unicode string?
  38. How well is Unicode supported in C++11?
  39. What Unicode characters represent “time”?
  40. Convert Unicode to ASCII without errors in Python
  41. TypeError: coercing to Unicode: need string or buffer, int found
  42. UnicodeDecodeError, invalid continuation byte
  43. Javascript: Unicode string to hex
  44. What exactly do “u” and “r” string flags do, and what are raw string literals?
  45. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  46. What’s the difference between UTF-8 and UTF-8 without BOM?
  47. Byte and char conversion in Java
  48. How to write unicode strings into a file?
  49. XML schema error – root element of a w3c xml schema
  50. What does _T stands for in a CString
  51. List of all unicode’s open/close brackets?
  52. JSON and escaping characters
  53. Japanese ASCII Code
  54. is there any plugin for auto taging with unicode support for wordpress?

Leave a Comment

tech