May 14, 2015 at 3:01 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy