Ssis 878 ~repack~ Guide

SELECT p.name AS PackageName, pr.referenced_object_name AS MissingTable FROM [catalog].[packages] p JOIN [catalog].[package_references] pr ON p.package_id = pr.package_id WHERE pr.referenced_object_type = 'Table' AND pr.referenced_object_name NOT IN (SELECT QUOTENAME(SCHEMA_NAME(schema_id))+'.'+QUOTENAME(name) FROM sys.tables); Note: This works only for explicit object references in the SSIS catalog. If you see SSIS error 878 (or 0x80040E37), don't chase permission or network issues first . Assume the table or view is missing, misnamed, or in the wrong database/schema. Validate the object, fix the name, and the error will resolve. Need more help? Search for "SSIS 0x80040E37" or "SQLSTATE 42S02" – these are the official terms. "SSIS 878" is a shorthand used in support forums, but now you know exactly what it means and how to fix it.