Search code examples
sql-serverssissql-server-agentsql-job

ssis package is not being execute with job scheduled on Agent

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.

Solution

  • This was solved by giving folder permission to the user from which the package was being executed.