Hi Guys,
I've got an SSIS package that gets run ad-hoc by a user. No schedule is needed or associated.
The user directly has the appropriate access, and when running within an SSiS/BIDS window works fine with Integrated Security.
However, for ease, I want them to be able to run it from a job. So its convenient rather than having to open up BIDS to run it.
Now when I do this, I need to grant the service account for Agent access... I want to avoid this.
So is it possible to run a job under the context of the user who click 'start job'
OR failing that, is it possible to run an SSIS package under the context of the person who clicked 'execute package' from within SSISDB?
Cheers All,
Alex