August 22, 2008 at 3:50 pm
Hi,
Though I have worked with SQL server and Informatica...I am new to SSIS.
I am trying to load XLS from SQL DB using SSIS.
I am getting below error.
Column Stdnum can not convert between unicode and non unicode string data types
I did googled for the error ..and put data Data Conversion Transformation to convert source Non Unicode string type to match target Unicode String type.
So mu source Stdnum column is varchar(20) DT_STR
I am using Data Conversion Transformation to change data type to DT_WSTR(255)
Target XLS column is Stdnum is DT_WSTR (255)
I am still getting same error.
Can I know what wrong I might be doing ?
Also I remember when I used to load XLS through Import - Export vizard /DTS never got such issue.
Its funny that 2 MS applications can not talk to each other smoothly.
Thanks in advance!
Abhishek
August 25, 2008 at 6:58 am
When you do a Data Conversion transform you get a new column and then you need to map the new column to the destination. I'm guessing you are still getting this error because you did not change your mapping at the Destination.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply