SSIS Packages won’t run as jobs – “Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
I recently found this out after Decommissioning a SQL server and moving the SQL Jobs to a newer SQL Server. I had setup a DNS alias for the server move to make things easier in the future. Not realising I had set this in the data source of the SSIS package. Annoignly from the new SQL Server this didn’t work. It appears I couldn’t use the DNS alias I had to use an IP. In this case I ended up using localhost as the SSIS packages are generally always based/sit on the SQL server itself.
Such an easy fix, but a good half hour of trouble-shooting!