June 24, 2013 at 8:58 am
Our team has several jobs in production using the old package deployment model. They have been running successfully and we haven't had any issues. However, we recently developed a new job that uses the project deployment model in SSIS 2012. It's a quick job that typically takes less than a minute. We set it up to run at 6:00 and 6:30 and it never fails consecutively. Since the beginning of the month, it has failed at:
-6/22 at 6:30
-6/18 at 6:30
-6/16 at 6:00
-6/13 at 6:00
-6/11 at 6:00
-6/10 at 6:00
Every other day and time not listed, it ran successfully. The job calls a few SSIS packages and processes a cube. The logs for the failures give almost no information. All that it says when it does fail is, "ended unexpectedly." When the failures occur, they are at different stages in the job and can happen after 6 seconds, 8 seconds, or 10 seconds, it appears to be completely random.
I know this is kind of a shot in the dark, but has anyone experienced similar problems with the new project deployment model? Any tips or ideas for ways to resolve the failures?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply