In SSIS, you typically see this as a or Execute SQL Task failure, and the error appears in the Execution Results tab or the job history (if run via SQL Server Agent).
A nightly SSIS package loads daily sales data into DW_Sales . It runs via a SQL Server Agent job under the service account NT SERVICE\SQLSERVERAGENT . After a weekend security hardening, the job starts failing with: SSIS-927