Jeff Moden (11/26/2012)

---

rhythm.varshney (11/26/2012)

---

Phil Parkin (11/26/2012)

---

rhythm.varshney (11/26/2012)

---

waiting for your valuable input guys........

You still have not asked a single question - there is nothing to respond to.

please suggest the way to get the data into my DB table based on above mentioned logic i.e how can I import data from my CSV to DB table considering above logic.

Personally, I wouldn't bother with SSIS with such a task. I'd use BULK INSERT into a staging table and write some good old fashioned "upsert" code to get the job done.

"Upsert" in this case (you're using 2005) means a simple conditional INSERT if the key data doesn't already exist and a simple conditional UPDATE if it does.

Using such a staging table would also allow you to do a lot of pre-validation and error checking before you ever allow the external unknown data anywhere near your existing data.