Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gavinjb
Starting Member
34 Posts |
 Posted - 2009-10-29 : 06:01:55
|
| Hi,I am trying to convert a process from SQL Server 2005 to 2008 but I am getting an error reporting that I am trying to convert from Unicode to non unicode data even though both the source and destination are non unicode.I have replicated a table from a SQL Server 2005 Database into 2008 and I am trying to use the same SQL in my SSIS 2008 Package to import the data into the table, but all I get is this uni code error what I don't understand is how can this work fine in 2005 but not 2008, can anyone help.Thanks,Gavin,Update: Forgot to mention I have even tried changing the Destination table to use nvarchar columns from varchar and still get the same error! |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-29 : 06:20:56
|
| When you changed the data type in the table, did you also change the datatype in the SSIS destination "Show Advanced Editor". There you have the option of changing the DataType from string [DT_STR] to Unicode string [DT_WSTR]. Or use the Data Conversion task to convert the data types.Apologizes if this doesn't help - I've not done this with an Oracle source. It worked with Excel. |
 |
|
|
gavinjb
Starting Member
34 Posts |
Posted - 2009-10-29 : 06:31:21
|
| Yes, I even tried dropping the destination and re creating it.Just found the problem one of the fields has had its data type changed from varchar to int and in SQL 2005 it is fine, but SQL 2008 seems to be a bit more fussy when moving an int to varchar, have fixed by changing the field in SQL to int |
|
|
|
|
|
|
SSIS Import from Oracle to SQL Unicode Error