Chelski_blue (7/17/2015)
So opened the package and changed the setting (having finally found it) to use EncryptSensitiveWithPassword. The package executes ok now through the Execute Package Utility, but pending confirm as to whether it runs through the SQL Agent Job.Seems a bit of a effort just because of an update to the stored procedure in SSMS to tweek a statement a bit.
Point being not changed the ssis process as such, just the coding of the sp it executes?
Bit like having to redecorate the house just because you moved a chair a bit to the left!!
As I implied earlier, your understanding is the same as mine: changing a proc slightly (but keeping the same contract) should not require any change whatsoever to the package. Something else is going on here.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.