Exactly thats what I want to do.

But the problem is lets say the very first time I load the data

Select * from ORACLETABLE where <Modified Date> <= (Select max <Modified...

On Oracle side I cannot add any column but, Oracle side it has Modified Date column which can help me to track the modified records and also new records.

But my...

Antares686,

I am trying to achieve the same thing.

I have built a package where my source is Oracle and Destination is SQL DB. In this package while transformation I have written...

I selected "Other Data Source" in Data Source pull down menu and then in User/System DSN I pointed to existing System DSN that points to the data source (Driver is...

Thanks! for the reply.

But how do I change to ORACLE OLEDB provider?

Can you please specify step by step process to change to ORACLE OLEDB Provider?

Thanks,

Thanks! for the reply.

But how do I change to ORACLE OLEDB provider?

Can you please specify step by step process to change to ORACLE OLEDB Provider?

Thanks,