| Author |
Topic |
|
jscot
Posting Yak Master
106 Posts |
 Posted - 2010-10-10 : 02:19:03
|
| HOW I CAN FIX THIS PROBLEM, SSIS PACKAGE ERROR " CANNOT CONVERT BETWEEN UNICODE AND NON UNICODE STRING DATA TYPE". I TRIED TO FIX THIS PROBLEM THROUGH " DATA CONVERSATION". THANKS. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-10 : 10:35:20
|
| change the output data type in the mappings tab of the conversion task |
 |
|
|
jscot
Posting Yak Master
106 Posts |
Posted - 2010-10-10 : 10:59:47
|
| I try to changed it but same problem. plz any suggestion. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-10 : 11:00:18
|
| You seem to have a problem with either your caps lock or shift key as well. Posting in all caps is the internet equivalent of shouting at people. Please don't.--Gail ShawSQL Server MVP |
|
|
|
jscot
Posting Yak Master
106 Posts |
Posted - 2010-10-10 : 12:17:08
|
| ohhhh sorry, Thanks for advice! Gail Shaw. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-10 : 16:45:04
|
| Are you sure that you changed all necessary columns? You can use the advanced editor to check the data types of the columns at each point in the data flow.--Gail ShawSQL Server MVP |
|
|
|
tooba111
Starting Member
22 Posts |
Posted - 2010-10-10 : 16:57:40
|
| I am just transferring only one column to double check what's the problem and still getting the same error " can't convert between unicode and non unicode". |
|
|
|
jscot
Posting Yak Master
106 Posts |
Posted - 2010-10-10 : 17:03:59
|
| Tooba i tried with only one column and facing same problem that you facing "Can't convert b/w unicode and non unicode" any suggestion? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-10 : 17:24:06
|
| The error means exactly what it's saying. Either the destination is unicode and the column that you've trying to insert is not, or the other way around.It's really hard to diagnose this remotely. Trace through the data flow. Check the data types at every step. Check exactly what task the failure is coming from. Check exactly what data type the destination is. Be aware that unicode is the default for strings in SSIS.--Gail ShawSQL Server MVP |
|
|
|
jscot
Posting Yak Master
106 Posts |
Posted - 2010-10-10 : 17:36:15
|
| Source data type is "CHAR(10)" and destination data type is "VARCHAR(15)". In "Data Conversion" Transformation1 data type is "Unicode String (DT_WSTR)" and "Data Conversion" Transformation2 data type is "String (DT_STR)", and still i m facing save problem. Please guide me where i m wrong. Thanks. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-10 : 20:35:42
|
| If the source is char and the destination varchar, you don't need a data conversion at all. They're both non-unicode strings.--Gail ShawSQL Server MVP |
|
|
|
jscot
Posting Yak Master
106 Posts |
Posted - 2010-10-11 : 08:50:56
|
| I am sorry source is (varchar(10) Excel File and i want to convert in data type "Date" OLED Table. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-11 : 09:28:18
|
| Then your data conversion needs to go to (I think) DB_Date, not unicode. Unless you have columns of type nchar/nvarchar you don't need unicode.--Gail ShawSQL Server MVP |
|
|
|
kvbc85
Starting Member
2 Posts |
Posted - 2010-11-04 : 07:03:29
|
| other wise use derived column and also make sure that length of datatype |
|
|
|
|
SSIS PACKAGE PROBLEM