Using SSIS Import a excel into existing table which already contains data

Question

I wana import a excel into SQL Server table which already contains data.My requiremnt is that if table already contains a row present in the excel then it should not get inserted. What & how should I use the data flow Transformation tool to prevent such type of data?

 

Thanks in Advance

Anurag

Answer 1

Hi, use a Look up with your Table which contains the data and match the columnsa and re-directlook up no match output to Table match putput can be sent to a OLEDB command.

 

---

Rakesh M J

Dont forget to mark it as Answered if found useful

MCTS,MCITP,MCSS

http://myspeakonbi.blogspot.com/

Answer 2

Hi Rakesh,

Thanks for ur suggetsion.

I was using the same but getting stuck at mapping time.

 

Thanks

Anurag

Answer 3

an UPSERT solution with Lookup described here:

http://rad.pasfu.com/index.php?/archives/46-SSIS-Upsert-With-Lookup-Transform.html

---

http://www.rad.pasfu.com