Urgent ~ Can we load OLEDB Source to Excel Destination Without Data Conversion Task

• subratnayak09

  SSC Eights!

  Points: 820

  More actions

  May 31, 2017 at 8:37 am

  #338013

  Hi,

     Can we avoid Data conversion task while loading data from Sql server to Excel destination .
  Error- "cannot convert unicode to non-unicode "

  Thnaks
  Subrat

• DamianC

  SSCrazy Eights

  Points: 8023

  More actions

  June 7, 2017 at 8:47 am

  #1945831

  Should depend upon the 'N' prefix on your source data type
  Can these be changed at source?

  - Damian

• tim.ffitch

  SSC Veteran

  Points: 292

  More actions

  June 9, 2017 at 9:53 am

  #1946208

  No, if your source fields are either CHAR or VARCHAR then you need to convert. If your source fields are NCHAR or NVARCHAR then you do not.

  You could change the data types in the database but then you must understand how this affects existing queries, primary and foreign keys etc.