Shum
Reputation: 41
How to get ssis package execution information during running process using ssisdb
I need to get package execution information from ssis db during runtime to log that information in my custom logging table. Is it possible to insert execution information during ssis package running on deployment?
Upvotes: 3
Views: 2541
Answers (1)
Hadi
Reputation: 37368
I think you are looking to read from SSISDB.catalog.executions and SSISDB.catalog.execution_component_phases tables.
TO move these rows to a custom logging table in real-time you may use triggers, i don't know if you can create triggers on SSISDB logging tables, but i think this is the only way to copy data in real-time.
Upvotes: 1
Related Questions
- Get the SQL Server Agent job that has run a particular execution of a deployed SSIS package
- Is it possible to log the files used in a SSIS package to a custom execution table?
- Get SQL queries which are executed from SSIS package on SQL Server
- SSIS Package - track calling job
- SSIS Package Execution from SSMS of SQL Server
- SSIS 2012 - How to Query Currently Running Packages in T-SQL?
- SSIS Package Execution from Visual Studio
- get ssis package output from SP
- SSIS Package tasks execution detail
- How to create report from SSIS package when its executed?