The purpose of this project is to provide a set of queries to easily extract data from SSISDB database, in order to get quick insight on:

• Running packages,
• Performance History
• Run outcome
• DataFlow statistics and performances
• Lookup component memory usage
• Lookup component duplicate warnings
• Errors
• Memory Warnings

The provided queries are also used in the ssis-dashboard project.

##Release Notes

Available scripts:

• ssis-execution-status: Latest executed packages
• ssis-execution-breakdown: Execution breakdown for a specific execution
• ssis-execution-dataflow-info: Data Flow information for a specific execution
• ssis-execution-log: Information/Warning/Error messages found in the log for a specific execution
• ssis-execution-lookup-cache-usage: Lookup usage for a specific package/execution
• ssis-execution-package-history: Execution historical data
• ssis-execution-parameter-values: Show execution parameter values

##Version History

###v 1.0

• First release

###v 1.1

• Improved & fixed the "ssis-execution-log" query

###v 1.2

• Added "ssis-execution-parameter-values" query