Hi All,
I got the above error message when I tried to execute job which included an SSIS package.
I tried the steps in the below link and it resolved the issue.
http://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/
You may still get error message. But check with the job once. You would have the job completed
If the job has not been completed then check for the sources that you have used for this job.
For example if you have designed a SSIS package where you are extracting data from excel sheet and transferring back to OLEDB then make sure that you have closed the excel files.
I got the above error message when I tried to execute job which included an SSIS package.
I tried the steps in the below link and it resolved the issue.
http://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/
You may still get error message. But check with the job once. You would have the job completed
If the job has not been completed then check for the sources that you have used for this job.
For example if you have designed a SSIS package where you are extracting data from excel sheet and transferring back to OLEDB then make sure that you have closed the excel files.
