Re: cannot convert between unicode and non-unicode data types

Mine is also Char 9 in Oracle, using the data transformation of dstr does not
change the error message I am trying to go into a nvarchar on Sql and never
in the older model was it so difficult.
--
cindy


"nick@xxxxxxxxxxxxxxxxxxx" wrote:

Exactly the same problem.

It's a bit rubbish that Microsoft product speaking to Microsoft
product can't actually produce a meaningful error message.

It doesn't really help that SSIS feels the need to produce a separate
set of definition strings - I know that my output is Char(9) since I
created it that way. Should that be DT_STR or not? It looks like it
should, but it's be nice if the helpfile was showing the
correlation.


On Sep 27, 11:56 pm, cindy <cme...@xxxxxxxxxxxxx> wrote:
Yes, numerous times I have inserted the transformation task between the
oracle and the sql database. I have choosen from the drop down list dstr and
the code page goes to ascii latin and executed there is very no change in the
error message. I have changed the datatype on the sql column to nchar, to
nvarchar also I must be missing a step and I am going on 8 hrs today with it.
Tried dumping to a raw file but the output is still unicode when I try to
import from file to sql table. Specifically after oledb connection to oracle
and pull data with query I insert data transformation I have six columns that
come back with error message In the data conversion interface I select
string(dt_str) with code page 1252
then I execute and same error message. I have 4 new packages now all with
the same one control task only, to pull in the data with a conversion.
--
cindy



"Paul Shapiro" wrote:
You can use a Data Conversion transformation. Add it between your data
source and the destination.

"cindy" <cme...@xxxxxxxxxxxxx> wrote in message
news:3369E769-5A87-41B8-AB6E-D014203EC27A@xxxxxxxxxxxxxxxx
I am converting a simple (at least in the SQL Server 2000 DTS days) to this
new SSIS. I have a data source (which is Oracle 8 using .Net ODBC
provider)
and am trying to pump the data into a SQL Server table. I get an error
that
it cannot convert between unicode and non-unicode data types. Any user
wrote in that basically the same I am just far more a beginner.
I am in the data transformation task as suggested and I confused as to the
drop down to be selected, in fact I have used all the string values. In
SSIS
I am new so is there a "rebuild" or do the changes I made in the
transformation stay operative when I run it if so I am confused because
the
error message stays the same
cindy- Hide quoted text -

- Show quoted text -



.

Relevant Pages