3

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:

enter image description here

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.

Trevor Reid
  • 3,310
  • 4
  • 27
  • 46
arcee123
  • 101
  • 9
  • 41
  • 118

1 Answers1

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:

Setting proxy account:

Hadi
  • 36,233
  • 13
  • 65
  • 124