Hi Team,
I am trying to implement CDC with inbuilt SQL Server Integration Services component (CDC control task) with different database.
Source db is Oracle 8.1 (Legacy Data)
Target db is Microsoft SQL server (Latest version)
We need to create ADO.net connection for CDC control task but oracle 8.1 does not support to create ADO.net connection as source is having old version of oracle.
As I know CDC control task accepts only ADO.net connection.
Could you please advice on this?
