SSIS Package fails to "Transform File and create output file"
This ended up being a Kerberos problem.  We were able to identify through some of the security logs and some network monitoring, that the request was coming in as anonymous.  Once we applied the relevant SPNs for MSSQLSVC for the account that was being used to kick off the process, it worked.