使用SSIS将数据从Oracle导入SQL Server时出现CodePage错误 [英] CodePage error while importing data from Oracle to SQL Server using SSIS

问题描述

我在SSIS包中的OLEDB源上收到以下警告.

I get the following warning on the OLEDB Source in the SSIS package.

警告1验证警告.数据流任务: {20582F6F-DD9C-45F5-8727-992F525E67DC}:无法检索列 OLE DB提供程序提供的代码页信息.如果组件支持 "DefaultCodePage"属性，该属性中的代码页将 使用.如果当前字符串代码更改属性的值 页面值不正确.如果组件不支持 属性，将使用组件区域设置ID中的代码页.

Warning 1 Validation warning. Data Flow Task: {20582F6F-DD9C-45F5-8727-992F525E67DC}: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

将AlwaysUseDefaultCoePage设置为true后，警告消失，但0行从源传输到目标.也没有显示错误.

After setting the AlwaysUseDefaultCoePage to true the warning disappears but 0 rows are transferred from source to destination. There is also no error shown.

更新:oracle服务器使用 US7ASCII 字符集.我找不到此字符集的代码页号.

Update: The oracle server uses the US7ASCII character set. I am unable to find the code page number for this character set.

推荐答案

US-ASCII(7位)的代码页标识符为 20127

Code page identifier for US-ASCII (7-bit) is 20127

您可以在以下链接中找到所有代码页标识符的列表.

You can find the list of all code page identifiers in the following link.

代码页标识符(MSDN)

以下链接也可以帮助您查找有关您的问题的其他信息:

Following link might also help you to find additional info with respect to your issue:

从oracle导入数据时出错数据库到SQL数据库

这篇关于使用SSIS将数据从Oracle导入SQL Server时出现CodePage错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！