2005 SSIS, SQL2Excel- varchar vs nvarchar

#1

Hi folks,
I have a problem to dts a SQL table to an excel file.
from: in data flow window, select a table, with one column, type varchar
to: in data flow window, Excel destination, defining the excel
file's path
When I execute the package, I got one error "cannot convert between unicode
and non-unicode string dataset:.
Then, I created another project. The only difference was the table
column type - from varchar to nvarchar. The execution was completed
successfully.
Please advise. Thanks.
Peter

#2

I figured out by meself. The solution is add an Data control" in the middle
to convert "varchar" to "DT_WSTR". The later is unicode, used in Excel.
Peter

"Peter" wrote:

Quote:

Hi folks,
I have a problem to dts a SQL table to an excel file.
from: in data flow window, select a table, with one column, type varchar
to: in data flow window, Excel destination, defining the excel
file's path
When I execute the package, I got one error "cannot convert between unicode
and non-unicode string dataset:.
Then, I created another project. The only difference was the table
column type - from varchar to nvarchar. The execution was completed
successfully.
Please advise. Thanks.
Peter

#3

Peter,

I just ran into this same error... I'm sort of new at this. How do I add a
Data control to convert it properly...
--
alan

"Peter" wrote:

Quote:

I figured out by meself. The solution is add an Data control" in the middle
to convert "varchar" to "DT_WSTR". The later is unicode, used in Excel.
Peter

"Peter" wrote:

Hi folks,
I have a problem to dts a SQL table to an excel file.
from: in data flow window, select a table, with one column, type varchar
to: in data flow window, Excel destination, defining the excel
file's path
When I execute the package, I got one error "cannot convert between unicode
and non-unicode string dataset:.
Then, I created another project. The only difference was the table
column type - from varchar to nvarchar. The execution was completed
successfully.
Please advise. Thanks.
Peter

#4

Hello LoanXEngine,

from the toolbox you can add a Data Conversion Transform to do the conversions
between datatypes.

Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:

Peter,

I just ran into this same error... I'm sort of new at this. How do I
add a Data control to convert it properly...

"Peter" wrote:

I figured out by meself. The solution is add an Data control" in the
middle to convert "varchar" to "DT_WSTR". The later is unicode, used
in Excel. Peter

"Peter" wrote:

Hi folks,
I have a problem to dts a SQL table to an excel file.
from: in data flow window, select a table, with one column,
type varchar
to: in data flow window, Excel destination, defining the
excel
file's path
When I execute the package, I got one error "cannot convert between
unicode
and non-unicode string dataset:.
Then, I created another project. The only difference was the table
column type - from varchar to nvarchar. The execution was completed
successfully.
Please advise. Thanks.
Peter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2005 SSIS, SQL2Excel- varchar vs nvarchar

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

2005 SSIS, SQL2Excel- varchar vs nvarchar - 11-07-2006 , 08:23 AM

RE: 2005 SSIS, SQL2Excel- varchar vs nvarchar - 11-07-2006 , 12:19 PM

RE: 2005 SSIS, SQL2Excel- varchar vs nvarchar - 11-28-2006 , 01:58 PM

RE: 2005 SSIS, SQL2Excel- varchar vs nvarchar - 11-28-2006 , 02:42 PM