I am trying to extract data from oracle table with ssis package in 2008 r2. I have setup the linked server. Everything was working fine but last few day it just stopped working. Job didn't fail just hang. When i run manually it just complete in 10 mins.