SSIS - why my process tasks keep ending with result 1 (thus failing SSIS package)

Question

I am trying to move the contents of a folder to another folder. Trying to keep this efficient, I decided to use a Process task:

While in SSDT, it works perfectly.

But when deployed to SQL Server SSIS on the same machine, it returns PROCESS EXIT 1 and fails the package.

Is there anything here that stands out that could prevent this from working? Thanks.

Answer 1

When SSIS packages are executed from SQL Server they access File System using the SQL Server Service Account NT SERVICE\MSSQL$<Instance Name> (Where <Instance Name> should be replaced by the installed instance name). You have to Grant this account to access the selected directories or run the SQL job using a proxy account:

SQL Server Serivce account Permissions:

• Configure File System Permissions for Database Engine Access

Setting proxy account:

• Running a SSIS Package from SQL Server Agent Using a Proxy Account
• Create a SQL Server Agent Proxy