1

I have a SSIS package that works great on its own, and even when I execute the package on SSMS. The problem comes in when I set it up as a job. Here is what the error message is, and of course any help would be much appreciated:

enter image description here

Eric Brandt
  • 7,886
  • 3
  • 18
  • 35
CalgaryCoolCat
  • 11
  • 3
  • See hyperlink above.. – CalgaryCoolCat Jan 31 '20 at 22:02
  • Duplicate of this I believe: https://stackoverflow.com/questions/57186227/ssis-package-runs-from-catalog-not-from-sql-server-agent-same-user – LaraRaraBoBara Jan 31 '20 at 22:05
  • 1
    The error messages give you the information you need. It is one of two issues. Either the id the job is running under does not have the proper permission to the directory or the server cannot find the directory. – Edney Holder Jan 31 '20 at 22:47

2 Answers2

0

Change the access rights to rwxrwxrwx for your destination file

CustMaster.csv needs access rights
Himanshu
  • 3,830
  • 2
  • 10
  • 29
0

The answer for me is:

Enter "Job step properties"

There enter "Configuration" -> "Advanced"

and check "32-bit runtime"

Solved my issue.

CalgaryCoolCat
  • 11
  • 3