Home Forums SQL Server 2005 SQL Server 2005 Integration Services Data conversion error in SSIS RE: Data conversion error in SSIS

  • 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));

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.