I have developed an SSIS package and deployed it on the SQL Server which uploads flat files in the database. I scheduled it to be run every 30 seconds. the job is being executed successfully but my SSIS package is not being executed. I mean I am not getting any result.
but while I am executing the package by right-clicking on the deployed package it gives me result.
Note - Scheduled job history doesn't show any error. it shows the success message of execution.
This was solved by giving folder permission to the user from which the package was being executed.