Data conversion error in SSIS

• mtz676

  SSCrazy Eights

  Points: 9261

  More actions

  May 14, 2015 at 3:01 am

  #398458

  I am trying to get the servername into a sql table.

  Sql:select @@servername as ServerName as SQL command.

  The above sql is part of OLE DB Source

  The OLE DB Destination has a table called Servers (servername (varchar(50))

  When I run this data flow in SSIS it shows an error : Cannot convert between a unicode and a non-unicode string data types

  How do I fix this.

  Thanks

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  May 14, 2015 at 3:14 am

  #1797767

  metroman17 (5/14/2015)

  ---

  I am trying to get the servername into a sql table.

  Sql:select @@servername as ServerName as SQL command.

  The above sql is part of OLE DB Source

  The OLE DB Destination has a table called Servers (servername (varchar(50))

  When I run this data flow in SSIS it shows an error : Cannot convert between a unicode and a non-unicode string data types

  How do I fix this.

  Thanks

  You could try

  select Servername = cast(@@servername as varchar(50));

  ---