Why wouldn't SSIS package running in SQL Server Agent job transfer files to a network folder? -

Why wouldn't SSIS package running in SQL Server Agent job transfer files to a network folder? -

i've run twice can run ssis bundle in bids , integration services fails when it's run through sql server agent. both of these packages transfer file final step folder on our network.

the error receive could not find part of path path , file name. when schedule them in windows task scheduler execute fine i'd rather have them run through sql server agent.

has run issue , found work around? there setting i'm missing in sql server?

any help appreciated.

you need run sql server job using proxy account configured run jobs of type sql server integration services packages. jobs run under sql server agent service account, not have access network folders. access network folders, need set proxy domain business relationship credentials (preferably) can access network path.

below reply in question has detailed steps on how set proxy account

how create step in sql server agent job run ssis package?

ssis