Hi, I am having an SSIS package stored at local drive with extension .dtsx. Now in database i have a job that executes that package. Earlier it was running fine but recently i modified it from then the package execution is failing. How can i view the exact error msg. When i tried opening that package the debug option is not visible.Thanks and regards, Rishabh

You should be able to see information about why the job is failing by looking at the job history in SQL Agent. Going forward, however - you should turn on Package Logging to make sure you record more information about how your packages are executing. Talk to me now on