Performance issue with selection of data on a table

I am creating an ETL which will read this table and generates an output. The performance is bad and it is because of the select query in this ETL i am trying to tune.

Thanks,eshwar.

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.