Experts,

I created a SSIS Package, which copies data( say a whole table)  from Oracle 10g to SQL Server 2014. which is working fine.

This job should run every day.

To copy the whole table , It is taking too long, As it is copying the whole table every day.

Is there a way the copy can happen only for the updated records?

Thanks & Regards

Praveen

Depending on your schema, yes.

SELECT *
  FROM sourceTable
 WHERE dateTimeColumn > (SELECT MAX(dateTimeColum) FROM targetTable)

CREATE TRIGGER first_trigger_test
on Triggertest
FOR UPDATE
AS
insert into Triggertest_audit select * from deleted
This need implemented in oracle.
data need inserted in mssql using link server..

If no linked server exists, you could put the MAX(dateTimeColumn) into a variable, and use it in your select.

Hi,

if currently you are are updating your table please do like that

first truncate source table and reload all data.

Regards,

Manish