I've scheduled a SSIS Package as a job using SQL Server Agent. This packages pulls data from Sybase source, process the data and store the data in SQL Server. This job runs for every hour. At most cases, this job is suceeded. But in certain runs, this job is failing. I'm getting the error message as below: Executed as user: ----. The step did not generate any output. The return value was unknown. The process exit code was -1073740940. The step failed. I'm unable to identify what the error is. How can i rectify this error? Can anyone help me on this? Regards, Ram

what is message in History log of job? right click on job and view log historyhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com

To investigate this further you should have package logging enabled, then you should be able to narrow it down hopefully to a particular task that is failing, if not enabled I would set that up in your package first choosing an appropriate logging destination and the next time it fails you should be able to get a more concise error message. Thanks/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem