Scheduling an SSIS package job
Hello,
I have an SSIS package that runs successfuly in SSIS server and Visual Studio. However, I scheduled the package as a SQL Agent job, and when I start the job, it runs for 5 seconds and finishes as success. But, it didn't
run the package...yet it treated it as success.
Has anyone encoutered such problems when scheduling an SSIS package to run as a job?
Thanks
Kajo
November 3rd, 2010 5:45pm
Hi Kajoo,
You need to enable logging in your package so you could see what happens inside a package.
See http://msdn.microsoft.com/en-us/library/ms138020.aspxSergei
Free Windows Admin Tool Kit Click here and download it now
November 3rd, 2010 6:33pm