使用SSIS将数据从Oracle导入SQL Server时出现CodePage错误

时间:2021-11-21 23:53:51

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

我在SSIS包中的OLEDB Source上收到以下警告。

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.

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

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

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

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

更新:oracle服务器使用US7ASCII字符集。我无法找到此字符集的代码页编号。

1 个解决方案

#1


7  

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

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

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

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

Code Page Identifiers (MSDN)

代码页标识符(MSDN)

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

以下链接也可以帮助您找到与您的问题相关的其他信息:

Error importing data from oracle database to an SQL database

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

#1


7  

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

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

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

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

Code Page Identifiers (MSDN)

代码页标识符(MSDN)

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

以下链接也可以帮助您找到与您的问题相关的其他信息:

Error importing data from oracle database to an SQL database

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