SSIS package is not terminating
I have a SSIS package which will execute a set of sql commands and some sps. there is one main sp in the pac开发者_开发知识库kage which will execute some sps in loop. But when i scheduled it as job in sql server, sps will be executed but it never comes out from the execution. It will stuck in that satage.
I would do some serious debugging here. It sounds like one of your stored procs either
1) has an endless loop somewhere or 2) there is a significant amount of blocking happening
精彩评论