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 file (.sql) as SQLSourceType as File connection in my execute sql task.
Thanks,
Tony.