rhythm.varshney (11/26/2012)

---

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.

Thanks Jeff.

Actually I did the same and suggested the same even wrote all UPSERT logic but my lead wants it to be implemented using ETL. Don't know why though I asked him that handling it in DB would be more easy to maintaing considering future changes and performance(as I read somewhere tha SSIS is not so good in update) also.

So could you please suggest the approach to get it done via SSIS.