A really great article indeed. Thanks.

Did you do Ltrim(Rtrim(ColumName)) for text file source columns? Leading or trailing blanks in strings might be the problem.

Of course!! Yes.

Raunak,

You are right. It is so bad that server will go mad :w00t:

I have read something like this on some other forum before. Original poster Ravi must be doing this...

This is what I came up with after reading your question. Its works well for large number of source ids and is based on assumption that you want to create...

This is kinda old article but still no tools you mentioned have become obsolete. I would like to mention SqlDBX personal which I think is very fast and good for...