CodePage error while importing data from Oracle to SQL Server using SSIS

Question

I get the following warning in OLEDB source in SSIS package.

Warning 1 Warning about validation. Data flow task: {20582F6F-DD9C-45F5-8727-992F525E67DC}: Unable to get the code page information column from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page of this property will be used. Change the property value if the current string code of the page value is incorrect. If the component does not support properties, the code page from the component's locale identifier will be used.

After setting the AlwaysUseDefaultCoePage parameter to true, the warning disappears, but 0 lines are transmitted from the source to the destination. Also, no error is displayed.

Update: oracle server uses US7ASCII character set . I cannot find the code page number for this character set.

Answer 1

Codepage ID for US-ASCII (7 bits) 20127

You can find a list of all codepage identifiers in the following link.

Codepage Identifiers (MSDN)

The following link may also help you find additional information on your problem:

Error importing data from oracle database to SQL database