SSIS data flow gets stuck reading table with no errors
DanGuzman from the above comments has pointed me in the right direction. The problem was with queries getting suspended in SQL server.
To resolve this issue, I  used SELECT statement with WITH (NOLOCK) option.