One of the great advantages of SSIS is the ability to add robust error handling to sql server jobs. I would suggest adding some error handling, or at least logging to your job and see what comes out.