DSXchange

Hi Guys
We are working on a migration project from V8.5 to V11.5 and Sybase to SQL Server. Currently facing the issue while comparing the data between Sybase and SQL Server tables and it is too much time consuming.

Is there a way by which we can develop a job which can compare the data between Sybase and SQL Server Table and get the difference.

This is what we have tried -
Src1 (SQL Server - RCP enabled) --->
Src2 (Sybase - RCP enabled)----------> Change Capture (All Keys, Explicit Values) --> Seq Stage

But job is aborting at reading the data from Sybase with below single fatal error -
Parallel job reports failure (code 139 error)

There are around 2000 tables that is why we want to automate the comparison. Manually this task is too difficult to complete

Did you try putting something like "code 139" into an exact search here? Many others have dealt with that message before, hopefully something here helps.