Jasdeep,

Came across same issue today for similar task you are doing and got it resolved by using ADO.Net source instead of OLEDBSource in Dataflow task.

Thanks..

Mahesh

select percent_complete from sys.dm_exec_requests where command like '%restore%'