• Ann Arbor, MI
ssis 878
Contribute

Ssis 878 Link | Pro

The Research, Preservation, and Distribution of Early Christian Culture

The Michigan Center for Early Christian Studies (MCECS) is working to bring the study of Christian origins and Christian antiquity into the center of higher education and intellectual discourse. 

Ssis 878 Link | Pro

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.

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.

We are a registered 501 (c) 3 non-profit, dedicated to the academic study of Christian Origins at the college level. Please consider supporting our work with a small donation!