SSIS Convert Between Unicode and Non-Unicode Error

by

The below Steps worked for me:

  1. right click on source task.

  2. click on “Show Advanced editor”.

advanced edit option for source task in ssis

  1. Go to “Input and Output Properties” tab.

  1. select the output column for which you are getting the error.

  2. Its data type will be “String[DT_STR]”.

  3. Change that data type to “Unicode String[DT_WSTR]”.

Changing the data type to unicode string

  1. save and close.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)