Ninja's_RGR'us, HowardW thank you both very much.

Ninja's_RGR'us: I don't like using SSIS. I am exhausted of clicking : )

I try to import xls file to tempTable(table2) and sometime users who export xls file delete one column. And column counts in tempTable(table2) are different than in table1(which is destination...

Thanks for advice. But there is no another application over it. It's pure SQL script.

Yes, I thought that, but how to insert this error to some log table ? How I catch this error ?

I have the same problem. How can I find it if there...