Sql server create SSIS job cannot get remote pc's data, but package can do that.

See more:

SQL

SSIS

remote

1. we create a package first at VS 2010, it use flat file source to get log files from remote PCs and can store data to local DB success;

2. then we deploy the package to Integration Services Catalogs -> SSISDB;

3. we use SQL server to create a SSIS job to run the package, but it didn't work, and shows the follow error 'The job failed. The Job was invoked by User sa. The last step to run was step 1 (L3_Z1A).';

What I have tried:

1. we try to get log files from local PC, the job run success,
but when we change the flat file path to remote PC, it failed;