SSIS包:在Unicode和非Unicode字符串数据类型之间转换 [英] SSIS Package: convert between unicode and non-unicode string data types
问题描述
我正在连接到Oracle DB,并且连接正常,但是某些列出现以下错误:
I am connecting to an Oracle DB and the connection works, but I get the following error for some of the columns:
Description: Column "RESOURCE_NAME" cannot convert between unicode
and non-unicode string data types.
RESOURCE_NAME的值:
Value for RESOURCE_NAME:
- 对于Oracle:
VARCHAR2(200 BYTE)
- 对于SQL Server:
VARCHAR(200 BYTE)
- For Oracle:
VARCHAR2(200 BYTE)
- For SQL Server:
VARCHAR(200 BYTE)
我可以通过Oracle SQL Developer连接到Oracle DB,而没有任何问题.另外,我的SSIS软件包设置为Run64BitRuntime = False
.
I can connect to the Oracle DB via Oracle SQL Developer without any issues. Also, I have the SSIS package setting Run64BitRuntime = False
.
推荐答案
Oracle数据类型VARCHAR2
似乎等同于SQL Server中的NVARCHAR
或SSIS中的DT_WSTR
. 参考
The Oracle data type VARCHAR2
appears to be equivalent to NVARCHAR
in SQL Server, or DT_WSTR
in SSIS. Reference
您将必须使用 数据转换转换 或SQL Server中的CAST
或CONVERT
函数进行转换.
You will have to convert using the Data Conversion Transformation, or CAST
or CONVERT
functions in SQL Server.
这篇关于SSIS包:在Unicode和非Unicode字符串数据类型之间转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!