Issue with a package running an package task from a job

• DamianC

  SSCrazy Eights

  Points: 8023

  More actions

  November 3, 2015 at 12:31 pm

  #399271

  Hi

  I have a SSIS project

  It has 7 packages; 6 child packages all called as tasks by a parent package

  If I execute this from Visual Studio it works

  If I add it as a step within a job, it fails

  It also fails if I deploy the package and try to run from SSMS

  The error states that their is no project to reference

  Does anybody know what would cause this?

  Thanks

  - Damian

• DamianC

  SSCrazy Eights

  Points: 8023

  More actions

  November 5, 2015 at 2:45 am

  #1837894

  I've fixed this issue by setting Protection level to DontSaveSensitive on ALL Packages

  Then re-deploying

  - Damian