Home All Groups Group Topic Archive Search About

non unicode

microsoft.public.sqlserver.server


Author
20 Apr 2007 7:43 AM
SB
Hi,
Is DT_STR Unicode?  From SSIS I am using a data conversion component
and defining the data type as DT_STR and saving the output in excel
file. I am getting an error that 'can not convert from Unicode to non-
unicode'. I thought I have already taken care of that in data
conversion.

Author
20 Apr 2007 8:10 AM
Gilberto Zampatti
Could you explain exactly which data conversion you prepared? The DT_STR was
specified for the input field or for the output? In this last case, which is
the input field data type?
Gilberto Zampatti

Show quoteHide quote
"SB" wrote:

> Hi,
> Is DT_STR Unicode?  From SSIS I am using a data conversion component
> and defining the data type as DT_STR and saving the output in excel
> file. I am getting an error that 'can not convert from Unicode to non-
> unicode'. I thought I have already taken care of that in data
> conversion.
>
>
Are all your drivers up to date? click for free checkup

Author
20 Apr 2007 8:50 AM
SB
On Apr 20, 2:10 pm, Gilberto Zampatti
<GilbertoZampa***@discussions.microsoft.com> wrote:
Show quoteHide quote
> Could you explain exactly which data conversion you prepared? The DT_STR was
> specified for the input field or for the output? In this last case, which is
> the input field data type?
> Gilberto Zampatti
>
>
>
> "SB" wrote:
> > Hi,
> > Is DT_STR Unicode?  From SSIS I am using a data conversion component
> > and defining the data type as DT_STR and saving the output in excel
> > file. I am getting an error that 'can not convert from Unicode to non-
> > unicode'. I thought I have already taken care of that in data
> > conversion.- Hide quoted text -
>
> - Show quoted text -

Hi,
DT_STR should be an input field because I am getting data from a table
using ole db source.
Author
20 Apr 2007 9:28 AM
Gilberto Zampatti
OK; supposing that input field is actually non-unicode (DT_STR could be the
right data type), verify the transformation task to be sure about the output
data type. SQL 2005 uses UNICODE by default, and you should explicitly
declare non unicode data types.
If you correct the input field definition specifying Unicode (DT_WSTR), you
should avoid such error message.
The fact that you are accessing input table via OLE DB does'nt change the
fact that QSL 2005 uses Unicode by default.
Gilberto Zampatti
Show quoteHide quote
"SB" wrote:

> On Apr 20, 2:10 pm, Gilberto Zampatti
> <GilbertoZampa***@discussions.microsoft.com> wrote:
> > Could you explain exactly which data conversion you prepared? The DT_STR was
> > specified for the input field or for the output? In this last case, which is
> > the input field data type?
> > Gilberto Zampatti
> >
> >
> >
> > "SB" wrote:
> > > Hi,
> > > Is DT_STR Unicode?  From SSIS I am using a data conversion component
> > > and defining the data type as DT_STR and saving the output in excel
> > > file. I am getting an error that 'can not convert from Unicode to non-
> > > unicode'. I thought I have already taken care of that in data
> > > conversion.- Hide quoted text -
> >
> > - Show quoted text -
>
> Hi,
> DT_STR should be an input field because I am getting data from a table
> using ole db source.
>
>
Author
20 Apr 2007 9:58 AM
SB
On Apr 20, 3:28 pm, Gilberto Zampatti
<GilbertoZampa***@discussions.microsoft.com> wrote:
Show quoteHide quote
> OK; supposing that input field is actually non-unicode (DT_STR could be the
> right data type), verify the transformation task to be sure about the output
> data type. SQL 2005 uses UNICODE by default, and you should explicitly
> declare non unicode data types.
> If you correct the input field definition specifying Unicode (DT_WSTR), you
> should avoid such error message.
> The fact that you are accessing input table via OLE DB does'nt change the
> fact that QSL 2005 uses Unicode by default.
> Gilberto Zampatti
>
>
>
> "SB" wrote:
> > On Apr 20, 2:10 pm, Gilberto Zampatti
> > <GilbertoZampa***@discussions.microsoft.com> wrote:
> > > Could you explain exactly which data conversion you prepared? The DT_STR was
> > > specified for the input field or for the output? In this last case, which is
> > > the input field data type?
> > > Gilberto Zampatti
>
> > > "SB" wrote:
> > > > Hi,
> > > > Is DT_STR Unicode?  From SSIS I am using a data conversion component
> > > > and defining the data type as DT_STR and saving the output in excel
> > > > file. I am getting an error that 'can not convert from Unicode to non-
> > > > unicode'. I thought I have already taken care of that in data
> > > > conversion.- Hide quoted text -
>
> > > - Show quoted text -
>
> > Hi,
> > DT_STR should be an input field because I am getting data from a table
> > using ole db source.- Hide quoted text -
>
> - Show quoted text -

Thanks.
For output I have created a excel table using the statement:
CREATE TABLE `Excel Destination` (
    `NAME` VARCHAR(),
)
I have tried string, text etc but no success.

Excel Destination editor:

Data Access Mode:
Table or view

Name of the excel sheet:
Excel Destination
Author
23 Apr 2007 4:41 AM
SB
On Apr 20, 3:28 pm, Gilberto Zampatti
<GilbertoZampa***@discussions.microsoft.com> wrote:
Show quoteHide quote
> OK; supposing that input field is actually non-unicode(DT_STR could be the
> right data type), verify the transformation task to be sure about the output
> data type. SQL 2005 usesUNICODEby default, and you should explicitly
> declare nonunicodedata types.
> If you correct the input field definition specifyingUnicode(DT_WSTR), you
> should avoid such error message.
> The fact that you are accessing input table via OLE DB does'nt change the
> fact that QSL 2005 usesUnicodeby default.
> Gilberto Zampatti
>
>
>
> "SB" wrote:
> > On Apr 20, 2:10 pm, Gilberto Zampatti
> > <GilbertoZampa***@discussions.microsoft.com> wrote:
> > > Could you explain exactly which data conversion you prepared? The DT_STR was
> > > specified for the input field or for the output? In this last case, which is
> > > the input field data type?
> > > Gilberto Zampatti
>
> > > "SB" wrote:
> > > > Hi,
> > > > Is DT_STRUnicode?  From SSIS I am using a data conversion component
> > > > and defining the data type as DT_STR and saving the output in excel
> > > > file. I am getting an error that 'can not convert fromUnicodeto non-
> > > >unicode'. I thought I have already taken care of that in data
> > > > conversion.- Hide quoted text -
>
> > > - Show quoted text -
>
> > Hi,
> > DT_STR should be an input field because I am getting data from a table
> > using ole db source.- Hide quoted text -
>
> - Show quoted text -

Hi,
Is it alright if I declare a datatype as nvarchar 'create table (name
nvarchar(20))' and then treat it as if varchar for example functions,
inserts and join with other varchar columns etc? Except giving a
larger string size I don't have much use for unicode. They might as
well keep this type internal so that we didn't have to worry about it.
Author
23 Apr 2007 4:54 AM
SB
On Apr 23, 10:41 am, SB <othell***@yahoo.com> wrote:
Show quoteHide quote
> On Apr 20, 3:28 pm, Gilberto Zampatti
>
>
>
>
>
> <GilbertoZampa***@discussions.microsoft.com> wrote:
> > OK; supposing that input field is actually non-unicode(DT_STR could be the
> > right data type), verify the transformation task to be sure about the output
> > data type. SQL 2005 usesUNICODEby default, and you should explicitly
> > declare nonunicodedata types.
> > If you correct the input field definition specifyingUnicode(DT_WSTR), you
> > should avoid such error message.
> > The fact that you are accessing input table via OLE DB does'nt change the
> > fact that QSL 2005 usesUnicodeby default.
> > Gilberto Zampatti
>
> > "SB" wrote:
> > > On Apr 20, 2:10 pm, Gilberto Zampatti
> > > <GilbertoZampa***@discussions.microsoft.com> wrote:
> > > > Could you explain exactly which data conversion you prepared? The DT_STR was
> > > > specified for the input field or for the output? In this last case, which is
> > > > the input field data type?
> > > > Gilberto Zampatti
>
> > > > "SB" wrote:
> > > > > Hi,
> > > > > Is DT_STRUnicode?  From SSIS I am using a data conversion component
> > > > > and defining the data type as DT_STR and saving the output in excel
> > > > > file. I am getting an error that 'can not convert fromUnicodeto non-
> > > > >unicode'. I thought I have already taken care of that in data
> > > > > conversion.- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > Hi,
> > > DT_STR should be an input field because I am getting data from a table
> > > using ole db source.- Hide quoted text -
>
> > - Show quoted text -
>
> Hi,
> Is it alright if I declare a datatype as nvarchar 'create table (name
> nvarchar(20))' and then treat it as if varchar for example functions,
> inserts and join with other varchar columns etc? Except giving a
> larger string size I don't have much use for unicode. They might as
> well keep this type internal so that we didn't have to worry about it.- Hide quoted text -
>
> - Show quoted text -

That question was not related to SSIS package (as you have told ssis
is unicode). FWIW I was able to get the data (ssis) imported when I
used unicode for input and output data using a data conversion in
between from varchar to unicode string.

Bookmark and Share

Post Other interesting topics
missing tables
At what point is schema information loaded?
recent SQL 2005 hotfix creates problem
Hyperthreaded CPU's
MS OLE DB provider for Oracle
attach vs restore
Adding Logons
Cannot create a Stored Procedure
set transaction isolation level read uncommitted
Help with moving DB from 2000 to 2005 folders