• The AMSCRYSTAL login is one provided by the vendor for the Oracle server only, it's not a valid account in SQL server.

    I noticed that my windows account worked because I built the linked server using my windows creds, tested it, and series of SSIS packages while logged in with my windows account. Never noticed an issue until I tried to schedule the packages as a SQL Agent job.