Hello, I have an SSIS package that runs successfuly in SSIS server and Visual Studio. However, the SQL Agent job that I created finishes running in a few seconds and displays a status of success. But, the package is never executed. Has anyone encoutered such problems when scheduling an SSIS package to run as a job? Thanks Kajo

I created a text file log for the package and redeployed the package and ran it but it does not write anything to the log. When I run the package in Visual Studio it writes the process to the log...it works in Visual Studio and SSIS Server. But not when I run it as a job in SQL Agent. ThanksKajo

It would be helpful to tell us what the error is... Check in the job history, you should be able to find the error there and then post it in this thread. Please 'Mark as Answer' if found helpful - Chris@tier-1-support

Can you post the details of how your job and job steps are configured?John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com