Post reply

Data conversion error in SSIS

  • 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

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply