I have a job which picks up a flat file and processes the file by insert records. The job is scheduled for every half an hour. It is a SSIS PKG But suddenly the job does not pick the file and process for hours. But the job is running. When i stop the file and re-ran the job , the job
picks up the files and process immediately. Kindly help on what could be the problem?