Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS Job Runs but package doesn't

Author  Topic 

mfemenel
Professor Frink

1421 Posts

Posted - 2008-11-12 : 13:36:24
Last night around 2 a.m. our SSIS packages ceased executing. THe jobs that kick them off run just fine but the packages don't appear to actually execute. No code changes have occured and I'm not really sure where to look at for this one. When I run the job manually it works fine. The jobs run under the SA account and nothing has changed for that account. I tried running the job under a different account (mine, I'm admin and SA) and the same problem happens. I did restart SSIS and that cured it for a few hours but the problem returned. I've tried restarting SSIS again but this time it is not helping the issue. I'm open to ideas.

Mike
"oh, that monkey is going to pay"
   

- Advertisement -