I am using SSIS 2008, I set a varaible @t1 to data type CHAR and set the value to
Y next I used an Execute SQL Task with an ADO.NET connection to SQL 2008 R2 database to insert this the value of @t1 into a test table with only 1 column of data type NCHAR(1):
insert into test1
On the Parameter Mapping section of this task I put the Data Type as String and initially set the Parameter size to
The only problem is it tries to insert a 2 character numeric value into the SQL table. If I set the value of @t1 to N the parameter mapping seems to convert this to
78, when I set the value of @t1 to Y the parameter mapping converts this to
89 it looks like it converts the character to an ASCII code.
Is this meant to be the intended behaviour, as all I wanted to do was insert the actual character into the destination column and not the ASCII code?
View Complete Post