Josh2442
asked on
SSIS Unicode Non Unicode Datatype issue
Hi I am using a simple ssis package to transfer data from oledb source into excel destination but keep getting the error message. 'Cannot convert between unicode and non unicode string datatype'.
My steps were:
Inside control flow I dragged a dataflow task. I double clicked it and dragged pledb source and set up the connection source for my data base. Then I dragged the excel destination and set up the connection and map the columns after which I get this error message. I think I have to use a data transformation but do not have any clue pf what I should do in it.
Thanks in advance
My steps were:
Inside control flow I dragged a dataflow task. I double clicked it and dragged pledb source and set up the connection source for my data base. Then I dragged the excel destination and set up the connection and map the columns after which I get this error message. I think I have to use a data transformation but do not have any clue pf what I should do in it.
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Old Table:
create table dbo.old(id int, Field1 varchar(15), Field2 varchar(200))
create view dbo.vnold
as
select id, cast(Field1 as nvarchar(15)) as 'Field1', cast(Field2 as nvarchar(200)) as 'Field2'
from dbo.old
create table dbo.old(id int, Field1 varchar(15), Field2 varchar(200))
create view dbo.vnold
as
select id, cast(Field1 as nvarchar(15)) as 'Field1', cast(Field2 as nvarchar(200)) as 'Field2'
from dbo.old
ASKER