Hi phil,

Actual the problem was i want to compare with the last modified date and above that date i want to load,your solutions are fine what you have given earlier,but...

Hi Sumit..

Can you briefly explain it,step by step.

Hi..

Is there any way to send mail after the job runs sucessful.

Hi, can you please send the solution for my e-mail:

narasimha.pothineni@syncoms.com

Regards..

Anil...

Thanks for your valuable suggestions,i will try both and i will get back to you if any queries..

Regards..

Anil..

Hi ..

please follow the rich suggestions and let us know about it.

Regards..

Anil..

Hi..

set the transaction property to required for sequence container,then if any task fails it will rollback

regards..

Anil..

Hi Jim ..

can you give brief explanation how to set environment variables.I am not getting how to set please dont mind.

Regards...

Anil...

Hi Raunak..

Yes i refered to the destination table andd performance is good,so they agreed with that,i fyou have any solution without referencing the destination table please post..

Regards..

Raunak..

Hi Dave..

We used i used the insert method what you have given,it works fine.thank you so much for your support.If any doubts i will post here please reply.

Regards..

Anil...

Hi Dave..

We have millions of records ,so comparing with reference table must take more time,so we dont want to lookup,i will try with that solution what you have given earlier,If...

Hi Dave..

Thank you for your valuable suggestion,rather than this if you have any solutions please post.I will show different solutions to my manager .

Regards..

Anil...

hi raunak..

Thanks for your help

Regards..

Anil...

Hi Sabya..

Thank you for your suggestion,and i have another query.

How to do incremental loading for each table,source and destiantion i can configure but what about the lookup table.

Is there any...

Hi..

If any one answered to this qusetion previous,please provide the link that would be helpful to me a lot.

Regards..

Anil...