Hi Lempster,

Thank You very much for your replay.

Exactly I am expecting row count. But the approach you have mentioned will not workout for my scenario because, I am executing query...

Thank you for quick response,

It can be update\Insert.

Thank's for you Replay.

The scenario is

Server 1:

ID Address

-------------------

1 USA

2 UK

3 ...

Thanq very much for you approch, It work for me 🙂

Thankq for your response. I need Mode column values as column name.

I thought CLR function gives better performance on string functions, so that I am looking for CLR function.

Thank's for your reply. I haven't stated any approch till now. I know we can do it from BCP. But I need to do this from SSIS package only.