Forum Discussion
krutikashirbhate
Jul 27, 2021Copper Contributor
CDC control task in SQL Server Integration Services for Legacy data
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?
No RepliesBe the first to reply