Thanks for the response.

I was so dumb I was not thinking in the other way .

It is so simple. Thnx a lot. 🙂

I have used the data conversion transformation.

It's giving me this following error:

"[Data Conversion [46]] Error: Data conversion failed while converting column "amount" (44) to column "Copy of amount" (140). ...

Ohh Yes..!!

I am using the invoice_date field.

DELETE FROM tableA

FROM tableA a

INNER JOIN (SELECT DISTINCT invoice_date FROM tableB) b

ON (a.invoice_date = b.invoice_date)

But this query deleting all the...

That link really helps.

The tables are not heavily indexed. I am using UnionAll, RowCount, DerivedCoulmn transformations.

I guess I have to use something like this query to insert new rows:

Delete src

...

Can you please tell me how to do the deltas??

This is the SQL: SELECT b.comp_code,

a.cust_code,

b.cust_name,

d.country_code,

e.country_desc,

a.item_code,

c.item_desc,

a.order_no,

a.reference_a_no,

a.reference_b_no,

a.po_no,

a.position_no,...

To extract last 9months data it is taking around 1hour.

And I am not using any complex queries only using few Left outer joins. The Main table has 4 million...