Home Forums SQL Server 2012 SQL 2012 - General Need list of ALL SSIS Package failures including their history RE: Need list of ALL SSIS Package failures including their history

  • thx Sagar -- the query in the link you provided (for SQL 2012) is good if you house pkg's in msdb...

    We're housing our SQL 2012 Enterprise SSIS pkg's in the Integration Services Catalog / SSISDB (in 4 predefined User folders)

    Our management would like to see every execution of every package over the last month... and it's status (success, failed)

    Was hoping someone might have a canned script to render this info..

    BT