locked
SSIS Package - Running Status RRS feed

  • Question

  • I have an SSIS Package that on certain days, it shows that the package is still running.  When I look at all executions, 3 different executions are stuck in running state, but then the next few executions show as succeed.  We've had issues where the drive that SSISDB is located has run out of space.  Could this be a determining factor as to why the executions are in a running state for certain days?  Are the other executions that show succeeded false positives?
    Tuesday, November 3, 2015 4:40 PM

Answers

  • Ok we figured out for sure it's the fact that SSISDB filled up the log.  It happens when we run the maintenance job "Server Maintenance Job" which supposedly cleans up the history, but at the same time, it's contributing to the log file growing too much on SSISDB
    Tuesday, November 3, 2015 8:05 PM

All replies