When executing an SSIS package from the command line, it works properly. However, when I run the same package from the SQL Job Agent, it fails.

When executing an SSIS package from the command line, it works properly. However, when I run the same package from the SQL Job Agent, it fails.

Make sure your SQL Job Agent user account has the following permissions:

  • COZYROC SSIS+ installation folder (READ and WRITE).
  • Windows temp folder (READ and WRITE). The default location is here: C:\Windows\TEMP
  • Permission to access COZYROC registry key.
  • Permission to access SQL Server registry key.