CODEWITHSUNDEEP
sql-serverssissql-server-agentsql-job
Shahab Haidar
Shahab Haidar

Reputation: 641

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.

Upvotes: 0

Views: 343

Answers (1)

Shahab Haidar
Shahab Haidar

Reputation: 641

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

Upvotes: 1

Related Questions