So I installed sql server locally and deployed a dtsx package to the integration services catalog from VS. SSISDB database is already there, so thought I'd create the SP there.
The aim for this is package to run once a month (unknown schedule as the day can be different each month), so the end user determines when to start this job.
I've been looking a various ways to execute it. I can successfully execute a job of SSIS type using proxy account to the dtsx.
Next looked at T-SQL calling a SP - also successful, then looked at putting the SP into a job (not sure if I need to) - this is where it errored.
I suppose I should be asking, what is the best way to execute the package as a user? It needs to be executed outside of SSMS, so thinking of a command/batch file or windows app (one of colleagues should be able to create) which calls the SP or references the file location of the dtsx.