Yes format is the same for all the files. They all are going to the same table and I do not have format file.

Each file has 3 columns and character...

Sure... I won't.. I actually didnt find the option to remove that...

Yup this works... great thanks very much John...

Thanks Much John...

If you use SQL Server 2008, then once you query this table and the output is in the grid then you will be able to just drag the column of...

Yes this works.. Thanks very much.

well I dont want to find duplicates from T2.

I want to find records from T2 which exists in T1 and make sure they are not inserted. Only those records which...

I updated statistics as well as rebuilt the indexes for this table.

well I already did dbccfreeproccache and it is still taking same time..

Yes that works.. Thanks

Thanks for the help... it worked...

I used Import Export wizard and that doesnt solve problem. SQL Server 2008 has this problem, it was working well if you use dtswiz with 2000/2005.

Also, my source text files are on my local machine and not on server. I cant copy that to actual server. So, Bulk Insert wont work.

Well there was no such need for this to me, I was just curious to know a way to get this....

SCOM 2007 would be a great choice...