My Oracle Support Banner

"bcp Out" Does Not Function when Using the ODI LKM "MSSQL to MSSQL(BCP) Control Append" (Doc ID 424347.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 10.1.3.9.99
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI), when using the Loading KM "MSSQL To MSSQL (BCP)" for transferring data between tables on the same Microsoft SQLServer RDBMS instance in two distinct databases, error messages are displayed and the Integration Interface interrupts.

More precisely, the "bcp IN" operation begins without the execution of the "bcp OUT".

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.