Validating records in a table

[Banky]

Hi I have a file with the following entities loaded in a temp table

idno
Caseno
passport no

Now I need to validate that this records are avalaible before going to the marching of this values in my temp table with my main table. How do I validate this records in my Temp Table. There are lots of records in the table so I think I will need a cursor. I am new to Sql. Someone pls help me asap

[ck9663]

Among the three columns, which is the link between your temp table and main table??

~~ CK

[Banky]

Thanks a lot I got it sorted and my DTS Package is running smoothly. In production now. Thanks

[sashi]

Why not share the solution with us :)