error with ssis package in sql server job

Решил проблему. Во-первых, сменил пользовательский DSN на системный. источник

Does any connection manager in the package use ODBC DSN? If any ODBC DSN is used, please make sure the DSN type is System DSN rather than User DSN. The user DSN may not be accessible when the user that create the DSN logs off.

Затем, создал новый proxy и дал ему другие права. источник

Use master
CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret = 'WindowLoginPassword'
Use msdb
Sp_add_proxy @proxy_name='MyProxy', @credential_name='MyCredential'
Sp_grant_login_to_proxy @login_name=' devlogin', @proxy_name='MyProxy'
Sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS'