So I have a SSIS package that completes successfully when ran from the SSDT/Vis Studio but fails when called from SQL Agent.
The error I receive from the SQL Agent is generic and doesnt hint what it is as below...
It just says "The package execution failed. The step failed."
So as for what the SSIS package does...
It makes a call to my database and grabs some records.
It then loops through all of the records and makes an API call to another one of my websites (a small API that deals with parsing documents e.g. pdfs etc)
The API that is called looks for a file e.g. pdf/word and parses it then saves it to the database, it can on occasion also write a new file to a folder
So my SQL Agent runs under the administration account from my server which has folder permissions to the above mentioned folder structure.
The small API also has folder permissions to the folder structure.
(Both read and write perms)
I am struggling to see what the issue is, any ideas would be great!