Read more
Category: SSIS
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), running […]
Read moreSQL server 2012: Kill SSIS package Execution in Integration Services catalog
Kill SSIS package in Integration Services catalog using tsql
Read more