Search code examples
sql-servert-sqlssissql-agent-job

SSIS Package when deployed as a scheduled package is not stopping


I have 3 packages out of which 2 are designed by me and 1 was designed by another developer.All the 3 packages have independent functionality.

I have deployed all the 3 packages as a scheduled jobs(3 independent scheduled jobs). The packages which i created are working fine as jobs.

But the package which the other developer has developed is in continuous loop and not getting completed.This package only copies data from one db to different db.

None of us have admin rights on this server. all the deployed packages executes through proxy account which has admin rights.

Please let me know how to solve the issue.

Thanks in advance


Solution

  • I run the deployed jobs through proxy account. The proxy account user did not have rights to one of the database where it will pull the data from. After granting the access to that database for the proxy user the deployed package worked successfully.

    Thank you all for your valuable time and suggestions.