Progress of SSIS cannot be done using 'RowCount' Variable as value of a rowcount variable is set only after the execution of 'Data flow task'
We can acheive this however by using a script Component.
Read through the steps here ..
Post contains my learning in asp.net, c# and sqlserver 2005.