Asked by:
SSIS catalog now showing as "Succeed" even though it has finished execution.

Question
-
Hi All,
we have master package which call child packages , some times we are seeing all packages were executed in logs but SSIS catlog not reporting as "Succeed", the status was still showing as "running" even after 3hrs. whats wrong?
Thanks,
Dileep
ADKR
Monday, September 16, 2019 10:47 AM
All replies
-
-
Hi Arthur,
Thanks for responding. i was referring to result set of below query. that was showing the last step of the Etl COMPLETED. but in catalog it was still showing as "Running"
SELECT e.execution_id,e.folder_name,e.project_name, es.execution_path,
DATEDIFF(MINUTE,es.start_time,es.end_time),es.start_time,es.end_time,
es.execution_duration,es.execution_result
FROM [internal].[executions] e JOIN [internal].[executable_statistics] es
ON e.execution_id=es.execution_id
WHERE
e.project_name='project name' AND e.execution_id=xxxxx
ORDER BY es.start_time descADKR
Monday, September 16, 2019 1:33 PM -
-
'project name' AND xxxxx are the place holders.
ADKR
Monday, September 16, 2019 3:09 PM -
-
Hi Arthur,
Thanks for responding. i was referring to result set of below query. that was showing the last step of the Etl COMPLETED. but in catalog it was still showing as "Running"
SELECT e.execution_id,e.folder_name,e.project_name, es.execution_path,
DATEDIFF(MINUTE,es.start_time,es.end_time),es.start_time,es.end_time,
es.execution_duration,es.execution_result
FROM [internal].[executions] e JOIN [internal].[executable_statistics] es
ON e.execution_id=es.execution_id
WHERE
e.project_name='project name' AND e.execution_id=xxxxx
ORDER BY es.start_time desc
ADKR
Hi Dileep,
Could you please share the result of the query?
The following link will be helpful:
How to check the SSIS package job results after it has completed its execution?
Best Regards,
Mona
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com- Proposed as answer by Mona LvMicrosoft contingent staff Wednesday, September 18, 2019 10:02 AM
Tuesday, September 17, 2019 6:22 AM