pramodsingla.com
SSIS 2012 (SSISDB)- Check execution status of SSIS Package
Problem Statement: How to check the execution status of a SSIS package, deployed in SSISDB, using system tables? Solution: DECLARE @status INT=2/*Running The possible values are created (1), runni…